How to enable Javascript

Latest Posts

Re: Address Verification/Enrichment Here is an good sample code about converting a python list to a data frame - https://stackoverflow.com/questions/35001229/create-dataframe-from-list-of-tuples-using-pyspark/35009289
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Full load and Increment Load with different Data Source ? When an incremental refresh is executed, Incorta always does a UPSERT to find the matched ID and update it and insert the row if the ID is not found. You cannot clear the data from one data set and…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How does the Max Groups Parameter work? Based on the explanations from Matthew, here are the best practices: Add the dashboard level prompt default filter to limit the size of data to be grouped when the user first open the dashboard Add…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Compare Data in 2 Sources We can use an Incorta Materialized View for this purpose. I have a script but the format is different. The table will have the key columns and the column name and the column value when there are…
Attachment
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 yr ago
- Questions & Answers
- Reported - view
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 yr 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 yr 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 yr 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 yr 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
- 1 yr 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
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Materialized views @Anil Kumar Katari You can enable Spark from CMC tenant configuration by entering the spark master URI. Under <incorta home>/IncortaNode in the server, run ./startSpark.…
- DylanEmployee
- Facebook
- Dylan_at_facebook
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 2 yrs ago
- 3 replies
- 179
- Questions & Answers

Back to top

Employee

Dylan

Dylan_at_facebook

Facebook

Constractor

Menlo Park

17
2
0

Follow