The Looker API allows you to programmatically manage your Looker environment. Learn how to do it here!
Fivetran Transformations makes cleaning straightforward. Check out the following methods.
Whenever you perform arithmetic across SQL columns, take care to handle NULL values appropriately.
Use Fivetran Transformations to prepare your data for reporting.
You don’t need Python chops to get started with simple predictive models, just BigQuery ML and Looker (Fivetran helps, too!).
Want to deploy a full-fledged data stack in minutes? Connect Fivetran through Snowflake Partner Connect, then connect Snowflake to Tableau. That's it!
We now offer five prebuilt AdWords reports to give you a head start on ad analytics.
Learn how to combine AWS Lambda and the new Fivetran REST API to build connector status dashboards.
Use Looker Blocks to conduct plug-and-play analyses with data from our standardized connectors.
Learn how to incrementally migrate data from Redshift tables using AWS Lambda.
Use SQL to group data so that you can spot trends, uncover opportunities, and see where and how your business generates value.
Using SQL to conduct funnel analysis can help you make sense of multiple facets of your business.
We walk you through the process of setting up a cloud function connector using Python and Google Cloud Platform Functions.
Use SQL queries with Zendesk data to assess help desk performance by employing metrics that offer quantitative insight into the efficiency of support teams.
Columnar databases, not OLTP databases, are the appropriate choice for a data warehouse.
ETL custom data sources into your data warehouse, using Fivetran and serverless cloud functions.
Why Saleforce’s formula and lookup fields can cause problems when integrating your data pipeline, and what you can do to get the information to your warehouse.