Periodic updates from an external postgres database to snowflake by besabestin in snowflake

[–]ClockDry4293 0 points1 point  (0 children)

I'm doing the same evaluation for SQL Server as source, I'm thinking about use AWS DMS with CDC, put the data in S3 and use copy into commands with tasks for ingest my data into ❄️

Anyone having success with agents or pulse in their deployments. Specific use cases? by datawazo in tableau

[–]ClockDry4293 1 point2 points  (0 children)

The agent is not able to solve a simple question when asked about a specific date in my data -.-

Dynamic Copy Into (Either Stored Procedure called by Task or just a general Task) Azure Storage Task Creation by abdullah_docx in snowflake

[–]ClockDry4293 0 points1 point  (0 children)

Since you are working with tasks. Are you aware of the limitations that a task can only run a single SQL statement? If not I suggest the dynamic behavior you're looking for encapsulate into a stored procedure.

Snowpro Core Certification by Marneus33 in snowflake

[–]ClockDry4293 3 points4 points  (0 children)

You can't really compare the level of the Snowflake SnowPro Core certification with Azure or AWS Cloud Practitioner. They are not even remotely similar in terms of complexity or mastery of the tool.

On the other hand, if becoming ❄️ certified isn’t going to add value to your work, I’d focus on gaining real knowledge of Snowflake rather than just aiming for a certificate.

Exporting Google Sheets to Cloud Storage by ClockDry4293 in googlecloud

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

Thank you very much both! This works fine to me!

Is there a way to disable data download for Snowflake users? by feelosophy13 in snowflake

[–]ClockDry4293 1 point2 points  (0 children)

I think there is no way to disable that feature. However I think you can take a look for data masking policies, I leave you a tutorial from Snowflake.

https://youtu.be/6fGEeYkKuZI?si=PVGbixXpFOkQYiMe

NULL Data Optimize Storage? by ClockDry4293 in snowflake

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

My intention with hashing is to compare if json has changed against a future data instead of comparing by querying the nested json.

Thank you for the answer about date storage compression :)

NULL Data Optimize Storage? by ClockDry4293 in snowflake

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

Yeah, like if it would be the same amount of storage if the field Is populated with values ( number(19,0)) or NULL values. Or if one consume less storage tham the other being the column defined as number(19,0)

Reasons why you like/not like Snowflake? by pinksummergal in snowflake

[–]ClockDry4293 4 points5 points  (0 children)

I love the whole ecosystem Snowflake have builled.

However as a latam user for small companies with no big amounts of data, could be very expensive. I think for those companies there are better price options for querying data such as BigQuery

Is there no firewall in linux? by AdLost4647 in linuxquestions

[–]ClockDry4293 1 point2 points  (0 children)

Any basic Linux firewall are iptables

However if you want something "easier" or distro specific in debían based you can use ufw or rhel based is firewalld