How to enable Javascript

Latest Posts

Re: How to convert timestamp to Date in MV In SQL: TO_DATE(CAST(unix_timestamp('2020-09-22 13:58:18') AS TIMESTAMP)) In dataframe: df=df.withColumn("DATE_INEFFECTIVE", F.to_date(F.lit('9999-12-31'),'yyyy-MM-dd'))
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Data Dictionary @Mukul Ranjan I shared the approach of using runtime security filter based on a session variable that returns a list of schema that a user has access. The session variable can be based on a MV that…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Data Dictionary @Mukul Ranjan Incorta metadata table PERMISSION and SCHEMA can help you to filter the business schema that are granted to the user.
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Large Excel file load Yes, it is a tomcat level setting for each analytics service node. Here is a workaround if you have the back-end server access or you can ask help from incorta admin:…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Using a variable as a field expression in functions I guess that you would like to evaluate different columns based on the login user? We can use CASE statement to accomplish this: CASE($user='user1', inList(SALES.COUNTRIES.…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Using a variable as a field expression in functions The first argument of inList should be a possible value of a country, not the name of the column. It performs a if the value is in the list of the 2nd value. Hope this helps
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Unable to see table in the formula builder The tables shown in formula builder for creating a formula column are the base table itself and all the parent tables and ancestor on the join path. The lookup function allows us to use any table.…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Scheduling Schema Loads between times I will probably schedule multiple daily jobs and put those scheduled jobs between those hours.
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Scheduling E-mail with Filters @joseph. delpercio We don't need to define it. $user is a system varable. The value is the loginname of the user.
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Is there a way to manually compact a table? I am afraid that there is no way to trigger compaction manually. After you enable Aways Compact option in the tenant setting, did you run a full load of the schemas?…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 5 mths ago
- Questions & Answers
- Reported - view
0
How Table Load Order and MV Load Order work?
For Incorta 3.x table load order, does higher mean it will load sooner or later. ie does 11 load before 10? also do materialized views and tables both use the same queue,…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 yr ago
- 3 replies
- 117
- Questions & Answers

Back to top

Employee

Dylan

Dylan_at_facebook

Facebook

Constractor

Menlo Park

13
2
0

Follow