About Victor_Lorente

Victor_Lorente · 03-22-2023

Hi, anyone experiencing this bug?Full project to reproduce it:https://github.com/vlorente1/aragonite_templated_filter/tree/masterAfter click on “Validation” button to parse the LookML code, it ends with no message and sever log shows:LookerSDK::Inter...

Victor_Lorente · 06-27-2022

If I have this LookML code:view: active_orders { derived_table: { sql: SELECT o.id FROM orders o WHERE order.date >= {% date_start report_date_filter %} AND order.date <= {% date_end report_date_filter %} ;; indexes: ["id"] } dimension: id { hidden: ...

Victor_Lorente · 11-12-2021

Figure out this SQL code:SELECT client_id, fn_getComplexCalculation(client_id, DATE(“10-01-2020”), DATE(“10-01-2021”)) FROM clientsLets assume that clients table is enough big and the function enough complex to have enough reason to run this SQL code...

Victor_Lorente · 04-19-2023

Hi Greta,Actually you don’t need to go with extensions to do what you want to do.Just use a single view with the liquid code into the `sql_table_name:` tag. You even could also use the liquid into each dimension if the column names from `country` and...

Victor_Lorente · 03-30-2023

Shows error as below with the above syntax given by you…The Amazon Redshift database encountered an error while running this query. ERROR: column "%m/%d/%y" does not exist in table_name ---------- This is working fine>dimension: result_for_date { Typ...

Victor_Lorente · 03-30-2023

What about using SQL to get the result already formatted from database? dimension: resultfor { type: string sql: CONCAT( 'Result For : ', DATE_FORMAT( ${admin_dt_date}, "%m/%d/%Y" )) ;; }

Victor_Lorente · 03-27-2023

Hi, The correct way to do what you want to do is to create a project per instance, import the LookML base project and override the constant that holds the connection string. https://cloud.google.com/looker/docs/importing-projects Hope this helps. tha...

Victor_Lorente · 03-23-2023

Hi,The correct way to do what you want to do is to create a project per instance, import the LookML base project and override the constant that holds the connection string.https://cloud.google.com/looker/docs/importing-projectsHope this helps.

My Stats

ibmapipoc's Bio

Badges Victor_Lorente Earned

Recent Activity

Looker bug in Aragonite parser with Liquid and filters

LookML DT to SQL and PRIMARY KEY

Emulate a function call in LookML

Re: Is it possible to extend two views and use a LookML parameter in the extended view?

Re: How to concat and convert date from from YYY-DD-MM to MM/DD/YYYY

Re: How to concat and convert date from from YYY-DD-MM to MM/DD/YYYY

Re: Dynamic connection string

Re: Dynamic connection string