View the original community article here
Last tested: Nov 13, 2019
Looker Currency Exchange Block Instructions for Big Query
For more information click here.
Here are some steps on how to set up the Currency Exchange Rate Block with a Big Query connection.
1. Go to Github
Fork the datablocks-exchangerate repo
2. Delete Snowflake files in the forked repo.
Click into the file and then click the trashcan. You can write a commit message if you would like.
3. In Looker go to Manage LookML Project. Create a new project.
Start with a blank project. Set up a GIT connection to the forked repo.
Shift-click on the git button and select Pull from production to download files from repo.
4. Create a new connection to BQ with PDTs enabled following the steps listed in the instructions here:
Double-check the connection by going to admin → connections → test connections.
**** If you already have a BQ connection with PDTs enabled, skip this step. ****
5. Change the connection name in the model file in the new project to the new connection or existing Big Query connection with PDT access.
*** You can also create explores for each view file. ***
6. Add a manifest file to the existing (original) project you want to extend the currency data to. You may have to enable the Project Import Labs feature. For more information click here.
The manifest file in the original project should look something like this:
7. Extend the files from the new project to the project you want to collaborate on. Here is the general doc on how to extend files.
In the example, the view files were included in the original project’s model file.
include: "//exchange_rate/*.view"
Then, the views were joined to existing explores in the original project.
For my example, the views were joined on dates.
There can be multiple entries for a date in the bites view. We do not generally recommend joining on dates, but if you do please use the raw date format. For more information click here.
Example join:
explore: bites {
label: "Dog Bites in NYC"
description: "List of all bites"
join: bq_forex {
type: left_outer
sql_on: ${bites.date_of_bite} = ${bq_forex.exchange_date} ;;
relationship: many_to_one
}
End Result!
This content is subject to limited support.