Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

BigQuery connector custom SQL in advanced editor

How can I edit the query SQL when I'm using the BigQuery connector? The bigQuery connector just allow me to select a table, but I need to make a different sql to correlate 2 tables with several giga...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you mhossain ,

     

    It is not option for the short term as I'm not admin of my machine and new SW takes usually 2 to 3 months to be approved and made available in company's itshop.

     

    I'v commented in another topic's comment, and I'm pasting here as well.

     

    As example, for oracle we can write in advanced editor:

    let
    Source = Oracle.Database("dbHost/db",[HierarchicalNavigation=true, Query="select field from table where condition"] )
    in
    Source

     

     

    Can I do the same with bigquery connector? how? I tried the same but the "Query" parameter does not work đŸ˜ž

     

     

     

    I'm using:

    let

       Source = GoogleBigQuery.Database([BillingProject="projectid"])
          {[Name="projectid"]}[Data]
             {[Name="myDataset",Kind="Schema"]}[Data]

                 {[Name="myTable",Kind="Table"]}[Data]

    in

       Source

     

    Documentation is not clear nor can't find the possible options for the connector

     

    Thanks to all

     

    • mhossain's avatar
      mhossain
      Solution Sage
      6 years ago

      Anonymous 

      Thanks for explaning so well, lets see if somebody can help here with the solution.