search

CreativeDataEU / PowerBITrinoConnector

A Micosoft Power BI Custom Connector allowing you to import Trino data into Power BI.
MIT License
38 stars 15 forks source link

Querying to trino API #7

Closed victor-msa closed 5 months ago

victor-msa commented 10 months ago

So far I tested the connector and it is great, kudos for taking the time and making a usefull tool. What I have in mind, is how to use specific querys, as in a select statement, with the connector, since I am not planning on using a whole table in my projects. How would someone do that?

pichlerpa commented 10 months ago

Hey @victor-msa,

Yes, I understand your requirement, in fact, there even is a built-in way of providing such a custom SQL statement, but it only works for ODBC connector: https://learn.microsoft.com/en-us/power-query/native-query-sdk

However, I guess it would also be possible to add this functionality somehow else by just providing a new custom field of type text. Apart from that, you could also provide a new view on the Trino side which wouldn’t require any adjustments in the connector.

Regards, Patrick

pichlerpa commented 5 months ago

@victor-msa I just updated the connector, it now supports native SQL queries.