How to enable Javascript

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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta 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 MascittiIncorta User
- Northwestern Mutual
- Mike_Mascitti
- 1 yr ago
- Questions & Answers
- Reported - view

Back to top

Incorta User

Mike Mascitti

Mike_Mascitti

Northwestern Mutual

Senior Engineer

Milwaukee, WI

17
2
1

Follow