Remove Data Remove Doc Remove Files
article thumbnail

Tip: How to add leading zero for zip codes in Google Docs

Judi Sohn

When Excel (or Google Docs) sees just numbers in a field, it assumes you want the field to be a number. But if you want to bring that spreadsheet to Google Docs, all that goes out the window because there’s no special setting in Google for zip codes. Go to Google Doc’s Edit menu and select “Paste Values Only&#.

Doc 140
article thumbnail

Optimize the dbt Doc Function with a CI

Towards Data Science

Although dbts {{ doc() }} function allows you to store and reuse descriptions for the columns of your models, ensuring its usage remains quite a manual process and prone to mistakes, and therefore can easily lead to incomplete or outdated documentation. files, which live in the docs folder of your dbtproject.

Doc 83
professionals

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Tip: How to add leading zero for zip codes in Google Docs

Judi Sohn

When Excel (or Google Docs) sees just numbers in a field, it assumes you want the field to be a number. But if you want to bring that spreadsheet to Google Docs, all that goes out the window because there's no special setting in Google for zip codes. Highlight the zip code column and format it as plain text.

Doc 124
article thumbnail

Smartsheet: Frustrated with online project management no longer

Judi Sohn

Why aren’t you just using Google Docs?” ” Yes, some of what we’re doing in Smartsheet could be done in Google Docs. It’s an Excel/Google Doc-like online app that generates spreadsheets that are more dynamic than just rows & columns. Right now we have 389 active sheets in our Team account.

Project 203
article thumbnail

dbt Core, Snowflake, and GitHub Actions: pet project for Data Engineers

Towards Data Science

Pet Project for Data/Analytics Engineers: Explore Modern Data Stack Tools — dbt Core, Snowflake, Fivetran, GitHub Actions. This hands-on experience will allow you to develop an end-to-end data lifecycle, from extracting data from your Google Calendar to presenting it in a Snowflake analytics dashboard. See Github repo.

Action 97
article thumbnail

Streamline Data Pipelines: How to Use WhyLogs with PySpark for Data Profiling and Validation

Towards Data Science

Streamline Data Pipelines: How to Use WhyLogs with PySpark for Effective Data Profiling and Validation Photo by Evan Dennis on Unsplash Data pipelines, made by data engineers or machine learning engineers, do more than just prepare data for reports or training models. It lets you log all sorts of data.

Profile 98
article thumbnail

Why you might want a secure file-sharing service now that you’re working from home

The Verge

We didn’t need to give sharing files much thought. But now that we’re scattered across the landscape, securely sharing important files can take careful planning. Here’s why you might want to use powerful file-sharing services to share sensitive files safely, so you can collaborate better no matter where you’re working.

Files 93