| {% macro trange_join(left_model, left_fields, left_primary_key, right_models) %} | |
| {# | |
| This macro allows the user to join two or more snapshot models together on a common | |
| key, with the result being a unique record for each distinct time range. For example, | |
| Given left_model: | |
| | {{ join_key }} | left_field | dbt_valid_from | dbt_valid_to | | |
| | - | - | - | - | | |
| | k1 | L1 | 2020-01-01 | 2020-01-05 | | |
| | k1 | L2 | 2020-01-05 | 2999-12-31 | |
| ''' | |
| Tableau Workbook Redshift->Snowflake Migrator | |
| ============================================= | |
| This is heavily based on previous work here https://github.com/calogica/tableau-redshift-snowflake-converter/blob/master/Tableau%20Redshift%20to%20Snowflake%20Migration%20Script.ipynb | |
| This script converts Tableau packaged workbooks from Redshift to Snowflake. It works by | |
| parsing the workbook XML. It will replace datasource connections so they point to your | |
| Snowflake instance instead of Redshift. Additionally, the script will UPCASE schemas, | |
| tables, and any columns that don't have characters that need to be quoted. |
| htrojans = 5 | |
| hbackups = 5 | |
| megs = 50 | |
| cash = 500 | |
| computer$ = "Apple Ie" | |
| backup$ = "Paper Strips" | |
| hack$ = "Yourself" | |
| intel$ = "no" | |
| dumbnerdone = 100 | |
| start: |
| require 'bundler/setup' | |
| require 'daru' | |
| require 'benchmark' | |
| require 'yaml' | |
| filename = 'Application_1470_20151111010006.txt' | |
| def bench(name, &block) | |
| time = Benchmark.realtime do |
Using instructions found http://robots.thoughtbot.com/using-rbenv-to-manage-rubies-and-gems and http://dan.carley.co/blog/2012/02/07/rbenv-and-bundler/. Here's how to get started with rbenv on OS X (assuming homebrew is installed):
brew update
brew install rbenv
Add the following lines to .bashrc:
| require 'rubygems' | |
| require 'bundler/setup' | |
| require 'rest_client' | |
| require 'yaml' | |
| require 'json' | |
| # Working example of using the GoodData REST API to download a report. | |
| # This demonstrates two different methods, one is to download the | |
| # the report as computed on the UI, the other is to download the |