mike_mascitti
Cosmonaut
since ‎06-24-2022
‎09-25-2023

User Statistics

  • 13 Posts
  • 0 Solutions
  • 3 Kudos given
  • 5 Kudos received

User Activity

Hello, I'm trying to setup a data alert when the data read from our source is not new.  What happens is, sometimes our external source table has not been updated when our Incorta Schema load runs and we end up pulling in no data for 'today'.  When th...
Hello, what is considered the best way to handle logins to the Incorta Postgres database (from a DB tool or from Power BI)?  We have SSO configured for our online access, and we use generic IDs for people to access the database.  Is there a way to al...
Hello - we are in the process of upgrading from 5.0 to 5.2 and have noticed a new requirement in 5.1.  Changing a 'Key' column in a physical table now requires a full load of that table.  We use incremental loads to load daily snapshots from source s...
Hello, we have a few use cases where we need to view a row from a table that's the most recent version of that row.  We have a table with rows with an ID and Row Effective Date, and we load incrementally over time.  Every now and then we'll get a new...
Does anyone have any good ideas on how to name their schemas and business schemas?We have different types of schemas - some pull data in externally, but others only use Alias tables from other schemas.  We have some that serve very specific purposes ...