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-- ...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
6 years ago

Hi @Siva_Venna

Can you please provide screenshot of the Snap where you are passing the table name?

Regards,
Spiro

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    6 years ago

    @Siva_Venna

    Can you please check if table that you want to query exist in the database and remove the brackets before Date.now() and after getFullYear().

    Also, you can try first to select the database schema name and then pick the appropriate table.

    • Siva_Venna's avatar
      Siva_Venna
      Contributor
      6 years ago

      @Spiro_Taleski I have checked manually the table exists and when I hard code the table name I am getting the records. As you suggested removed the brackets yet same error.the output preview is as expected.

      • SpiroTaleski's avatar
        SpiroTaleski
        Valued Contributor
        6 years ago

        @Siva_Venna

        Did you try to pass a table name value from the upstream mapper snap?