How to enable Javascript

Latest Posts

0
Metadata tracking for Field descriptions
Is there any way to access the metadata on Business Schemas? Specifically, I'd like to have the Description field available externally so Power BI users can see it.…
- Mike Mascitti
- Northwestern Mutual
- Mike_Mascitti
- 4 mths ago
- 1 reply
- 14
- Questions & Answers
0
Tables and Views not displayed in external tools.
Hello, we have experienced an issue regularly where Schemas and Business Schemas don't always show up in the list of available tables/views when listing the tables in an external tool like Dbeaver…
- Mike Mascitti
- Northwestern Mutual
- Mike_Mascitti
- 4 mths ago
- 1 reply
- 28
- Questions & Answers
Re: Difference in data between Incorta Insight and generated SQL Output Hi Ishaq, In my understanding, queries will be handled differently between SQL and what you'll see in an insight because of how Incorta performs joins.…
- Mike Mascitti
- Northwestern Mutual
- Mike_Mascitti
- 4 mths ago
- 3
- Questions & Answers
- Reported - view
Re: How to share a personalized dashboard? I just found the small pull tabs in the upper left corner of each Insight that allow you re-arrange the Original View of the dashboard! That solves it for me!
- Mike Mascitti
- Northwestern Mutual
- Mike_Mascitti
- 8 mths ago
- Questions & Answers
- Reported - view
0
How to share a personalized dashboard?
Is it possible to change the layout of a dashboard and share that layout with others? It appears that you can only change the layout of a dashboard when you personalize it,…
- Mike Mascitti
- Northwestern Mutual
- Mike_Mascitti
- 8 mths ago
- 1 reply
- 20
- Questions & Answers
Re: Full load and Increment Load with different Data Source ? I use different tables in my full and incremental load because we have a table of daily activity and a table of history. We pull from the daily activity table every day for an incremental load,…
- Mike Mascitti
- Northwestern Mutual
- Mike_Mascitti
- 8 mths ago
- Questions & Answers
- Reported - view
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
- Northwestern Mutual
- Mike_Mascitti
- 9 mths 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
- Northwestern Mutual
- Mike_Mascitti
- 9 mths 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
- Northwestern Mutual
- Mike_Mascitti
- 9 mths 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
- Northwestern Mutual
- Mike_Mascitti
- 11 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
- Northwestern Mutual
- Mike_Mascitti
- 11 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
- Northwestern Mutual
- Mike_Mascitti
- 11 mths ago
- 2 replies
- 29
- 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
- Northwestern Mutual
- Mike_Mascitti
- 11 mths ago
- 3 replies
- 36
- Questions & Answers
Re: Customizing logo and background Image by Creating/Modifying Custom CSS File @Mike Mascitti Nevermind - clearing my cache fixed it!
- Mike Mascitti
- Northwestern Mutual
- Mike_Mascitti
- 1 yr 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
- Northwestern Mutual
- Mike_Mascitti
- 1 yr 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
- Northwestern Mutual
- Mike_Mascitti
- 1 yr ago
- 5 replies
- 30
- 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
- Northwestern Mutual
- Mike_Mascitti
- 1 yr 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
- Northwestern Mutual
- Mike_Mascitti
- 1 yr 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
- Northwestern Mutual
- Mike_Mascitti
- 1 yr 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
- 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
- Northwestern Mutual
- Mike_Mascitti
- 1 yr ago
- 3 replies
- 74
- 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
- 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
- Northwestern Mutual
- Mike_Mascitti
- 1 yr ago
- Questions & Answers
- Reported - view

Back to top

Mike Mascitti

Mike_Mascitti

Northwestern Mutual

Engineering Manager

Milwaukee, WI

23
5
1

Follow

https://www.linkedin.com/in/michael-mascitti-5980b233/