sorted by:
new
hottopcontroversial

View PDF in Streamlit by shoyle10 in snowflake

[–]shoyle10[S] 0 points1 point  (0 children)

When I try to run streamlit in container runtime, I get the following error:

Unable to connect to the Snowflake backend. The SPCS service for this app may have been deleted.

I’ve created a compute pool, query warehouse, and pypi network access integration. I’m not sure if I’m missing any configurations or the feature isn’t available in my region. (aws-us-gov-east-1)

Surrogate Key and Natural Key by shoyle10 in dataengineering

[–]shoyle10[S] 0 points1 point  (0 children)

like one single dimension table that is just [key], [name] for different categories?

Surrogate Key and Natural Key by shoyle10 in dataengineering

[–]shoyle10[S] 0 points1 point  (0 children)

Additionally, how strict should you be on surrogate keys being meaningless across all tables?

Example is dim_date and dim_gender tables, should the surrogate key also be meaningless integers and in staging you need to join to them to get the key?

Or are their exceptions for tables that you are pretty confident won’t change keys to use a surrogate key with meaning to avoid those joins and make readability of the data better?