Incorta
Community
Learn
Docs
Support
How to enable Javascript
Login
Sign Up
Login
Search
Home
Latest Posts
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…
Dylan
Employee
Facebook
Dylan_at_facebook
12 days 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…
Dylan
Employee
Facebook
Dylan_at_facebook
13 days 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
Dylan
Employee
Facebook
Dylan_at_facebook
1 mth 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'))
Dylan
Employee
Facebook
Dylan_at_facebook
4 mths 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…
Dylan
Employee
Facebook
Dylan_at_facebook
4 mths 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.
Dylan
Employee
Facebook
Dylan_at_facebook
4 mths 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:…
Dylan
Employee
Facebook
Dylan_at_facebook
4 mths 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.…
Dylan
Employee
Facebook
Dylan_at_facebook
5 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
Dylan
Employee
Facebook
Dylan_at_facebook
5 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.…
Dylan
Employee
Facebook
Dylan_at_facebook
6 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.
Dylan
Employee
Facebook
Dylan_at_facebook
8 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.
Dylan
Employee
Facebook
Dylan_at_facebook
8 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?…
Dylan
Employee
Facebook
Dylan_at_facebook
8 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,…
Dylan
Employee
Facebook
Dylan_at_facebook
1 yr ago
3
replies
126
Questions & Answers
Employee
Dylan
Dylan_at_facebook
Facebook
Constractor
Menlo Park
16
2
0
Follow
Login
Sign Up
Home
Community
Questions & Answers
Events
Knowledge Base
Product Announcements
Learn
Help Articles
Product Videos
Introduction to Incorta (17 Videos)
How To Videos
Tags
View all tags
Product Announcement
Incorta 4.9
is now Generally Available (GA)!!!