Skip to content

Instantly share code, notes, and snippets.

@vvgsrk
vvgsrk / Setup_Azure_SCIM_Integration_with_Snowflake.sql
Created August 10, 2022 18:50
Setup Azure SCIM Integration with Snowflake
USE ROLE accountadmin;
CREATE ROLE IF NOT EXISTS aad_provisioner;
GRANT CREATE USER ON ACCOUNT TO ROLE aad_provisioner;
GRANT CREATE ROLE ON ACCOUNT TO ROLE aad_provisioner;
GRANT ROLE aad_provisioner TO ROLE accountadmin;
CREATE OR REPLACE SECURITY INTEGRATION aad_provisioning
@vvgsrk
vvgsrk / montior_replication_and_related_objects.sql
Last active September 15, 2022 06:27
SQL statements to monitor or troubleshoot replication and related objects
@vvgsrk
vvgsrk / create_secondary_database.sql
Created June 30, 2022 13:43
Create secondary database
-- Create a replica of the primary database in the traget account
CREATE DATABASE AMADEUS_DYNAMIC_PRICING
AS REPLICA OF ORGANIZATION_CODE.ORGANIZATION_NAME.AMADEUS_DYNAMIC_PRICING;
-- Refresh a secondary database
ALTER DATABASE AMADEUS_DYNAMIC_PRICING REFRESH;
@vvgsrk
vvgsrk / enable_replication.sql
Created June 30, 2022 12:58
Enable replication
-- Modify an existing permanent database to serve as a primary database using following statement
ALTER DATABASE amadeus_dynamic_pricing ENABLE REPLICATION TO ACCOUNTS ORGANIZATION_CODE.ORGANIZATION_NAME IGNORE EDITION CHECK;
@aparrish
aparrish / spacy_intro.ipynb
Last active March 14, 2025 21:43
NLP Concepts with spaCy. Code examples released under CC0 https://creativecommons.org/choose/zero/, other text released under CC BY 4.0 https://creativecommons.org/licenses/by/4.0/
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.