Incorta
Community
Learn
Docs
Support
How to enable Javascript
Login
Sign Up
Login
Search
Home
Latest Posts
Re: Date /time zone adjustment
@Dan Brock Hi Dan - Yes, we also had an issue with an incremental load. Our source system has a date column as part of the key, but it's not a datetime.…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
2 wk ago
Questions & Answers
Reported - view
Re: Date /time zone adjustment
I have tested this in our environment and I've tried both changing the time zone on the EC2 server OS and using your method within the startService script.…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
2 wk ago
Questions & Answers
Reported - view
Re: Aggregate Filter by Formula
Hello - are the above solutions still the best way to use an aggregated formula as a filter? There have been a couple releases since the last comment, but I wasn't able to get it to work when I…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
1 mth ago
Questions & Answers
Reported - view
Re: Connecting with SQLAlchemy
Hi Dan, in the SQL log I see the following.... It appears that the very first character can not be interpreted. ERROR: [15:20:59] [sqli | incmifhlb@incorta | Protocol]Caused by: net.sf.jsqlparser.…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
2 mths ago
Questions & Answers
Reported - view
Re: How to login from external tools with SSO?
Hi Anurag, Using Power BI via the cloud (is that Power BI Service) is something we have the option to do. However, most of our users connect via the desktop and our database connection tool…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
2 mths ago
Questions & Answers
Reported - view
0
How to login from external tools with SSO?
We have Single Sign-On (SSO) turned on for our Incorta environments, but we also plan on connecting externally with tools like Power BI. Problem is, with SSO for the UI enabled we need separate…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
2 mths ago
2
replies
19
Questions & Answers
0
Connecting with SQLAlchemy
Has anyone ever tried to connect to Incorta externally using the python package SQLAlchemy? We're trying to use it along side the python driver psycopg2 and we get the error 'Failed to Parse query'…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
2 mths ago
3
replies
23
Questions & Answers
Re: Customizing logo and background Image by Creating/Modifying Custom CSS File
@Mike Mascitti Nevermind - clearing my cache fixed it!
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
3 mths ago
Help Articles
Reported - view
Re: Customizing logo and background Image by Creating/Modifying Custom CSS File
Hello, I've tried these modifications, but the only one that works is the changing of the banner color. Changing the logo or adding text hasn't worked.…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
3 mths ago
Help Articles
Reported - view
0
How to link insights from different sources using a common filter?
Hello, I'm trying to link insights together so they filter on the same key, but the insights have different sources. For example: one insight is based off a business schema with a few select fields…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
3 mths ago
5
replies
18
Questions & Answers
Re: Upsert for Incremental Loading
@joseph. delpercio To answer your question above... Whatever field(s) you label as 'Key' in the load details tell Incorta how to define a unique row. If you load a row in Incremental load that has…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
8 mths ago
Questions & Answers
Reported - view
Re: Upsert for Incremental Loading
If I understand correctly, it sounds like you want to pull new rows without having a timestamp or anything that helps identify them as new. If you can't put something in the query to only pull new…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
8 mths ago
1
Questions & Answers
Reported - view
Re: Upsert for Incremental Loading
Hi Joseph - you can do this with a SQL hashbytes function. It allows you to pick whatever fields you want and creates a hash key out of them. Then just make the HashKey the primary Key on the…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
8 mths ago
1
Questions & Answers
Reported - view
Re: How do you join tables loaded incrementally?
Hi Amit, thanks for the response. I initially added date as part of the key because the document I found (linked above) on creating sparse snapshots had step 2 as 'create keys on last_modified_date…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
1 yr ago
Questions & Answers
Reported - view
0
How do you join tables loaded incrementally?
Hello, as a new user I'm hoping there's a standard recommended approach to this. When tables are loaded incrementally they use a Last Modified Date (or hash key) to only load new or changed rows to…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
1 yr ago
3
replies
62
Questions & Answers
Re: Incremental load
Hi Dan, thanks for the response. I've tried the following and gotten a couple different errors. In your example, when I do this in an incremental load...…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
1 yr ago
Questions & Answers
Reported - view
Re: Incremental load
Hello, I've got the same question as the original post. From the above responses, it looks like it's possible, but 'how' is it done? In my example I'd have a field (called CheckSum) that would…
Mike Mascitti
Incorta User
Northwestern Mutual
Mike_Mascitti
1 yr ago
Questions & Answers
Reported - view
Incorta User
Mike Mascitti
Mike_Mascitti
Northwestern Mutual
Senior Engineer
Milwaukee, WI
17
2
1
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)!!!