CartoDB / CartoDB-SQL-API

CartoDB SQL API
BSD 3-Clause "New" or "Revised" License
62 stars 63 forks source link

SELECT cdb_cartodbfytable({table_name}) ERROR column does not exist #677

Closed akira-fukue closed 3 years ago

akira-fukue commented 3 years ago

I tried to run this query to make my new table visible

documentation

table_name = 'table_test_001'
sql = f'SELECT cdb_cartodbfytable( {table_name} );'

with Python and the API understood that the parameter is a column anf i got an error

akira-fukue commented 3 years ago

I managed to solve, but need to update the documentation

the right way to call the function is

right : cdb_cartodbfytable( '{table_name}' );

wrong : cdb_cartodbfytable( {table_name} );

In my case I also had to use the username in the same way