Forum Discussion

Siva_Venna's avatar
Siva_Venna
Contributor
6 years ago

Table name in SQL select snap

Hi, I have few tables on SQL server like abc_2020 abc_2019 abc_2018 I want to query the the table that has suffix as current year. I have specified the value in the settings > table name-- ...
christwr's avatar
christwr
Contributor III
6 years ago

Seems like “failed to retrieve metadata” would be more about preview and the snap trying to pull and suggest fields and such for where clause, etc. Do you get this error when you actually run/execute the pipeline, or only when previewing/configuring?

  • Siva_Venna's avatar
    Siva_Venna
    Contributor
    6 years ago

    @christwr I am getting this error when previewing and executing.