gvisniuc

/*
This procedure will take the full path of a Snowflake table (Database, Schema and Table name) and will deduplicate it using a rotation mechanism.

To minimize waste we first check if the count of the rows of the table is the same as the unique.

If not, given a table A, we create a deduplicated version A_DEDUP.

Table A is renamed to A_ROTATE

A_DEDUP is renamed to  A

ML-engineer

import duckdb
from google.cloud import bigquery

bqclient = bigquery.Client()
table = bigquery.TableReference.from_string(
    "bigquery-public-data.utility_us.country_code_iso"
)
rows = bqclient.list_rows(table)
country_code_iso = rows.to_arrow(create_bqstorage_client=True)
cursor = duckdb.connect()

titan-teej

USE ROLE ACCOUNTADMIN;
USE WAREHOUSE <warehouse_name>;

WITH privileged_users_check AS PROCEDURE()
RETURNS TABLE()
LANGUAGE PYTHON
RUNTIME_VERSION = '3.9'
PACKAGES = ('snowflake-snowpark-python')
HANDLER = 'main'
EXECUTE AS CALLER