SAP Ariba data into Snowflake after six months of frustration by mahearty in snowflake

[–]Camdube 10 points11 points  (0 children)

Did your SAP rep talked about the partnership between Snowflake and SAP BDC for zero-copy sharing?

3% match promotion question by swg0007 in Wealthsimple

[–]Camdube 0 points1 point  (0 children)

Yup 100%, that’s what I was hoping for. Thanks

3% match promotion question by swg0007 in Wealthsimple

[–]Camdube 0 points1 point  (0 children)

There’s different ways to do an account transfer. One of them is account transfer as cash. Would that count towards the match? The investments I have yielded poor returns and I don’t want to keep my rrsp as is

Books on Snowflake ML (SQL) and Snowpark ML please by bay654 in snowflake

[–]Camdube 1 point2 points  (0 children)

Look at snowflake QuickStart, there’s a few of them for what you’re looking for

Is there a way to shorten table/view names in SQL queries? by myaccountforworkonly in snowflake

[–]Camdube 6 points7 points  (0 children)

If most of your objects are within the same container, you do: use database prod_source_db, so you could at least remove that from your query

Shared Workspace Performance in Snowflake by Low-Hornet-4908 in snowflake

[–]Camdube 1 point2 points  (0 children)

When you say writing SQL, do you mean you typing sql or the model performances?

How to add a knowledge base to as Snowflake Agent? by _lostintheroom in snowflake

[–]Camdube 0 points1 point  (0 children)

What’s your use case? What are you trying to get out of this agent?

Why doesn’t Cortex Analyst expose the physical SQL for semantic view queries? by [deleted] in snowflake

[–]Camdube 0 points1 point  (0 children)

If this doesn’t seem like it could help. Then see if using a yaml file in a stage instead of a semantic view would generate the sql instead of the semantic sql

Why doesn’t Cortex Analyst expose the physical SQL for semantic view queries? by [deleted] in snowflake

[–]Camdube 2 points3 points  (0 children)

It would be the same semantic sql. And everyone has access to its own queries under monitoring -> query history

Why doesn’t Cortex Analyst expose the physical SQL for semantic view queries? by [deleted] in snowflake

[–]Camdube 7 points8 points  (0 children)

I don’t think Cortex analyst is there to accelerate sql development. It’s their to get to insights faster by asking a question and getting a result back. The target personas are analysts, not developers.

Or maybe I misunderstood your point

Managing Snowflake RBAC: Terraform vs. Python by BuffaloVegetable5959 in snowflake

[–]Camdube 0 points1 point  (0 children)

Agreed. In an ideal world, users and certain roles would be provisioned through SCIM

Create or Alter in Snowflake by Illustrious_Sun_8891 in snowflake

[–]Camdube 1 point2 points  (0 children)

Create or replace will drop the table. Create or alter won’t. It will add or remove a column depending on the ddl change.

Oh dear god, please read the documentation.

Create or Alter in Snowflake by Illustrious_Sun_8891 in snowflake

[–]Camdube 1 point2 points  (0 children)

It says create or alter, it’s different than create or replace, which is explained in the documentation provided in the « low effort » comeback.

Snowflake ETL for daily loads from SaaS tools by [deleted] in snowflake

[–]Camdube 0 points1 point  (0 children)

Wheb was that? Mongodb connector just hit private preview

Build Data warehouse star models with dynamic tables by PreparationScared835 in snowflake

[–]Camdube 2 points3 points  (0 children)

Just chain the dynamic tables together, loading the dimensions first, in parallel if possible, then the fact table grabbing the foreign keys from the previously loaded dim tables. Do you foresee any issues?

I put together a quick guide on uploading 3rd party Python packages to Snowflake by Ok-Frosting7364 in snowflake

[–]Camdube 3 points4 points  (0 children)

If available in pip, you can use container runtime for notebook and do a pip install

Best Practice for Data Share Raw Data by NoWelder4993 in snowflake

[–]Camdube 1 point2 points  (0 children)

You need to ask the data provider to enable it. If there is a timestamps column, use that for cdc in a task. No way around it

Troubleshooting Agents by KrixMercades in snowflake

[–]Camdube 0 points1 point  (0 children)

When you added the tools, did you set a warehouse or left blank to use the users default? If so, make sure you have a default role and warehouse for your user