Channel

python Tag

Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their...

Often when using grid variables in Matillion, the order of the values is important. For example, you could be iterating through the values of a grid variable sequentially using the Grid Iterator component and need the iterations to complete in a desired order. You may even have...

While my day-to-day is spent working within Curator’s PHP platform, my favorite programming language is Python. I used it daily in a previous life after learning it on the job nearly two decades ago. I’m not going to lie—when I first started learning it, I...

This post covers how to automate the fetching and pushing of a Matillion project's local git repository with its remote counterpart using the Python Script component. If you would prefer, I also have a similar post that leverages the Bash Script component. Requirements Your Matillion project...

In the last few years, we have seen an ever-growing number of codeless data-prep solutions made available to analysts and developers. At InterWorks, we are constantly vetting these technologies, especially those that are extensible with powerful integrations with scripting languages like Python. Tableau Prep is...

Geocoding addresses in a scalable and sustainable way has always been surprisingly difficult in the BI world, let alone in Tableau. You either need expensive datasets/services, overkill GIS tools, or you must rely on very legally dubious usage of seemingly free (but not really free)...

Tableau Prep has improved considerably since it was launched. It offers a lot of tools to pre-process and transform your data. But sometimes, you need to apply a function that has no equivalent in Prep, want to extract some data using an API interface or...

Earlier in this series we have discussed how to load data into Snowflake using several different methods: Snowflake's user interface, the SnowSQL command line tool and Python. These three methods all perform the same task of loading data into Snowflake; however, they increase in complexity and...

As a Snowflake user and a Python enthusiast, I was very happy to learn that Snowflake has created its own Python package to connect to Snowflake and execute commands. As these commands are executed locally and transmitted to Snowflake, the full SnowSQL functionality is available...

Me: “I’ll take Python for $200, Trebek.” Trebek: “The time it takes for you to create a hand-coded XIRR calculation in Python for use in Tableau’s TabPy?” Me: “What is ‘a long time’?” Trebek: “Correct!” That’s right—you can now calculate XIRR in Tableau!  But it’s not going to be...

A client recently had a challenge wanting to use Exasol’s User-Defined Functions with a Python script, but they were having a hard time coming up with the right syntax to get it working properly. There’s a good deal of documentation out there, though much of...

After attending an in-depth technical training in Dallas, Texas, I thought it could be beneficial to give some examples of how Snowflake is unique in a series of blog posts moving forward. This week, I’m talking about JSON (although Snowflake’s functionality displayed in the article...

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!