[rawgabbit]

Having tried a variety of tools, I usually return to Snowflake. Within Snowflake, I don't use notebooks; instead, I prefer to create database Views to contain my code. I may have Views that call other Views etc. I like Snowflake because for every query in its UI, it automatically profiles the results it returns. e.g., for each column it gives a frequency distribution histogram of the values within the column. In short, I like the ability to store my code in something I can easily backup and re-use without adding a lot of other tools.

[platypii]

Makes sense. I'm not currently in snowflake because I'm mostly working with local parquet files. Would prefer not to have to pay for snowflake just to explore my data. I'm interested in better data UIs though so I might need to check it out.

[rawgabbit]

To keep costs down. I use standard edition with x-small data warehouse. The biggest cost driver is CPU or how long queries run.