Postgre queries datestamp timestamptz joins wont work in Metabase?

Get Help
1

Hey team,

I am trying to understand why a query would work in the postgre database and other applications but not in Metabase.

I have a datelookup table which I am trying to join with datasources on date field type, the query works when I run it in the database and Yellowfin BI. But when I run it in Metabase it results in nothing.
Why?

ga_adwords.report.“start-date”
Field: timestamptz

ga_adwords.datelookup.date_actual
Field Type: date

Example Query
SELECT
ga_adwords.report.“CPC”,
ga_adwords.report.“CPM”,
ga_adwords.report.“CTR”,
ga_adwords.report."_rjm_record_hash",
ga_adwords.report."_sdc_batched_at",
ga_adwords.report."_sdc_received_at",
ga_adwords.report."_sdc_sequence",
ga_adwords.report."_sdc_table_version",
ga_adwords.report.“adClicks”,
ga_adwords.report.“adContent”,
ga_adwords.report.“adCost”,
ga_adwords.report.“adDestinationUrl”,
ga_adwords.report.“adGroup”,
ga_adwords.report.bounces,
ga_adwords.report.“date”,
ga_adwords.report.“end-date”,
ga_adwords.report.impressions,
ga_adwords.report.keyword,
ga_adwords.report.medium,
ga_adwords.report.sessions,
ga_adwords.report.“source”,
ga_adwords.report.“start-date”,
ga_adwords.report.users,
ga_adwords.datelookup.date_dim_id,
ga_adwords.datelookup.epoch,
ga_adwords.datelookup.day_suffix,
ga_adwords.datelookup.day_name,
ga_adwords.datelookup.day_of_week,
ga_adwords.datelookup.day_of_month,
ga_adwords.datelookup.day_of_quarter,
ga_adwords.datelookup.day_of_year,
ga_adwords.datelookup.week_of_month,
ga_adwords.datelookup.week_of_year,
ga_adwords.datelookup.week_of_year_iso,
ga_adwords.datelookup.month_actual,
ga_adwords.datelookup.month_name,
ga_adwords.datelookup.month_name_abbreviated,
ga_adwords.datelookup.quarter_actual,
ga_adwords.datelookup.quarter_name,
ga_adwords.datelookup.year_actual,
ga_adwords.datelookup.first_day_of_week,
ga_adwords.datelookup.last_day_of_week,
ga_adwords.datelookup.first_day_of_month,
ga_adwords.datelookup.last_day_of_month,
ga_adwords.datelookup.first_day_of_quarter,
ga_adwords.datelookup.last_day_of_quarter,
ga_adwords.datelookup.first_day_of_year,
ga_adwords.datelookup.last_day_of_year,
ga_adwords.datelookup.mmyyyy,
ga_adwords.datelookup.mmddyyyy,
ga_adwords.datelookup.ddmmyyyy,
ga_adwords.datelookup.yyyymmdd,
ga_adwords.datelookup.month_year,
ga_adwords.datelookup.month_year_abbreviated,
ga_adwords.datelookup.weekend_indr,
ga_adwords.datelookup.date_actual
FROM
ga_adwords.report
INNER JOIN ga_adwords.datelookup ON ga_adwords.report.“start-date” = ga_adwords.datelookup.date_actual

2

Think I found a solution

::timestamp::date

FROM ((ga_adwords.report
JOIN ga_adwords.“Google_Source_Translations” ON ((report.source = (“Google_Source_Translations”.“Google Source”)::text)))
JOIN ga_adwords.datelookup ON ((((report.“start-date”)::timestamp without time zone)::date = datelookup.date_actual)));

3

Doubles the query time from 9 seconds to 20 seconds when I test the change in the DB via navicat

Is the a more efficient manner to achieve this?