iiinova — where your digital self keeps evolving

I’m exploring Titan Core for two key use cases: Deploying base infrastructure for new Snowflake accounts, using templates for databases, roles, warehouses, integrations, and account configurations.

110

Alejandro Gonzalez @alejandrogbu.bsky.social · 24/11/2024

Titan Core lets you define roles, privileges, and resources with YAML or Python, generating SQL to ensure consistency and reusability.

120

Alejandro Gonzalez @alejandrogbu.bsky.social · 24/11/2024

RBAC (Role-Based Access Control) is key for managing permissions in Snowflake, but scaling it with SQL scripts can get complex. Titan Core created by @teej.bsky.social simplifies this process.

181

Alejandro Gonzalez @alejandrogbu.bsky.social · 17/11/2024

Testing Iceberg tables in Snowflake with dbt! Curious to see if it becomes the standard for open table formats #databs

Code example showing how to configure Iceberg tables in Snowflake using dbt, including materializations like Table, Incremental, and Dynamic Table with parameters such as table_format, external_volume, and base_location_subpath.

000

Alejandro Gonzalez @alejandrogbu.bsky.social · 16/11/2024

Hello World from Python SDK

030

Alejandro Gonzalez @alejandrogbu.bsky.social · 16/11/2024

In the Chicago open data portal there are quite a few datasets very well documented and exposed via API. In particular I'm using a dataset that has all the crimes in the city since 2001, it's quite interesting: data.cityofchicago.org/Public-Safet...

data.cityofchicago.org

Crimes - 2001 to Present | City of Chicago | Data Portal

110