drewbanin

with hourly_pressure as (
    select
        t as date_time
        , t::date as date_day
        , hour(t) as date_hour
        , v:main:pressure::int as pressure_mbars
        , pressure_mbars / 1000.0 as pressure_bars
        , v:city.country as country
        , v:city.name as city
        

drewbanin

Package                    Version  
-------------------------- ---------
agate                      1.6.1    
asn1crypto                 1.3.0    
attrs                      19.3.0   
azure-common               1.1.25   
azure-storage-blob         2.1.0    
azure-storage-common       2.1.0    
Babel                      2.8.0    
boto3                      1.11.17  

drewbanin

diff --git a/website/docs/docs/building-a-dbt-project/package-management.md b/website/docs/docs/building-a-dbt-project/package-management.md
index 7d808a0..15201a0 100644
--- a/website/docs/docs/building-a-dbt-project/package-management.md
+++ b/website/docs/docs/building-a-dbt-project/package-management.md
@@ -174,10 +174,11 @@ As of 0.17.0, if the package version you want is only specified as `major`.`mino
 
 <File name='packages.yml'>
  
- ```yaml
- packages:

drewbanin

Senior Product Manager

At Fishtown Analytics, our mission is to empower analysts to create and disseminate organizational knowledge. The product we build, dbt, is used and loved by thousands of companies with more joining every day. We’re looking for a senior product manager to drive forward development of dbt Cloud and build the analytics engineering tools of the future.

Today, dbt Cloud supports the development, deployment, and discovery of datasets in data warehouses like BigQuery, Snowflake, and Redshift. By leveraging dbt Core (open source), dbt Cloud provides novel and compelling user interfaces into the modern analytics workflow. This cross-functional role will require coordination across engineering, design, marketing, sales, and customer success.

Who we are

Fishtown Analytics was founded in 2016 by three former RJMetrics employees. While at RJMetrics, we developed strong opinions on how companies should practice analytics. Specifically, we believe that:

drewbanin

dbt 0.17.0 - Octavius Catto (June 8th, 2020)

Breaking changes

• Added a new dbt_project.yml version format. This emits a deprecation warning currently, but support for the existing version will be removed in a future dbt version (#2300, #2312)
• The graph object available in some dbt contexts now has an additional member sources (along side the existing nodes). Sources have been removed from nodes and added to sources instead (#2312)
• The 'location' field has been removed from bigquery catalogs (#2382)
• The list_relations_without_caching, drop_schema, and create_schema macros and methods now accept a single argument of a Relation object with no identifier field. (#2411)

Features

drewbanin

/*
  Run with: dbt run-operation clone_prod_to_target --args 'from: analytics.analytics'
*/

{% macro clone_prod_to_target(from) %}

    {% set sql -%}
        create schema if not exists {{ target.database }}.{{ target.schema }} clone {{ from }};
    {%- endset %}

drewbanin

{{config(
    materialized = 'table',
    partition_by = { 'field': 'created_at_timestamp', 'data_type': 'timestamp' }
)}}

select
 timestamp(created_at) as created_at_timestamp,
 ...

drewbanin

with dogs as (
  select parse_json($$
  {
    "animals": {
      "dogs": {
          "labrador": {
              "name": "Labrador",
              "weight": 23
          },
          "boxer": {

drewbanin

select
    collector_tstamp,
    se_category,
    se_action,
    parse_json(se_action)
    
from raw.snowplow.event

where collector_tstamp > '2020-04-28'

drewbanin

agate==1.6.1
asn1crypto==0.24.0
attrs==19.3.0
azure-common==1.1.23
azure-nspkg==2.0.0
azure-storage==0.36.0
azure-storage-blob==2.1.0
azure-storage-common==2.1.0
Babel==2.7.0
boto3==1.7.55