Data source migration
Best practices around migration for looker from redshift sql to databricks sql.
Forum Posts
Date Range Control compatibility with AWS Redshift: to_timestamp(numeric) does not exist
There’s likely a compatibility issue on `to_timestamp()` with AWS Redshift and the following is the error that...
Connect Tableau to Looker database
I use Looker to manage my data stored in Amazon RedShift database. Though Looker has dash-boarding capabilitie...
LookML error "Can't construct persistent derived table"
I created datagroup and persistent derived table as below. but it keeps giving me an error. model```connection...
can't connect to redshift - a sporadic issue that started yesterday
We are seeing a sporadic issue b/w looker and redshift. This was started yesterday. Our Redshift connection us...
Has anyone successfully created a View for Redshift stl_load_errors table?
I want to analyze the errors we are getting in our Redshift stl_load_errors table.In my development environmen...
Dynamically choose the table using Date filter values without adding new filters/parameters.
Hello All,I have a derived table for monthly data and a dashboard based on that. But when users are trying to ...
Seasonal Sales Forecasting
Scenario In a related post, I illustrated a pattern that allows for some lightweight linear forecasting of mea...
Redshift Spectrum and Looker
Hi all! Have you get error like this: The Amazon Redshift database encountered an error while running this que...
Using Amazon Redshift’s new Spectrum Feature
At the AWS Summit on Wednesday, April 19th, 2017, Amazon announced a new Redshift feature called Spectrum. You...