To give some context: I'm using a single dataset for my connection to Snowflake and parametrized schema and tables names so that I can specify the exact schema and table in the Copy activity. In my pipelines, I am using both uppercase and lowercase table names, depending on the...
In June of 2023, we presented atSnowflake Summiton how Capital One designed and built our own monitoring and observability solution for Snowflake data applications. Let’s review the importance of data observability and the steps we took to ensure the quality and performance ofSnowflakedata pipeli...
The feature that allows a user to execute a stored procedure even if he does not have permission to access the tables referenced in the stored procedure, is called: Ownership chaining The security object that is required in order to enable transparent data encryption, is: Master Key...
Execute SSIS package activity Azure SQL Database (Preview) Lineage extraction for stored procedure executions Azure Synapse Analytics Copy activity Data flow activity Data storage systems Databases & storage solutions such as Oracle, Teradata, and SAP have query engines to transform data using scripting...