It would be excellent if I could declare variables somehow. I don't know how this would be implemented, but I use Presto so much for repeated queries that it would be nice to be able to just change variables at the top instead of manually changing values (for instance, dates that are used many times throughout the query) by hand.10 votes
We are reviewing technical feasibility & options for supporting variables / parameters in Presto.
Hive and Presto jobs can export data to AWS S3 but the destination prefix for the file is hardcoded in the result export configuration.
Some users want to programmatically export data from TD to S3 in 'chunks' and would like the ability to setup a scheduled job that export to a destination file in S3 whose name is defined by a variable, such as the job ID, the execution date/time, or other unique identifier.20 votes
We are looking into feasibility.
DataConnector support for google spreadsheet to get data would be useful.
We often use google spreadsheet for manage master data & want to import data by using replace mode everyday.10 votes
This should be pretty self explanatory. Currently TD supports only one timestamp column, while many tables will have more than one timestamp field. It's clumsy to have to store timestamps as strings, and then perform conversion each time the field is used.10 votes
Currently exploring feasibility of multiple timestamp columns.
It would be nice to support like plpythonu not only SQL based UDF.
Of course, I don't care If it wouldn't support file I/O and network access.7 votes
Thanks for the suggestion! This is something we are actively discussing internally.
Override yml file parameter by specifying option when run command issued.
Command option flexibility helps integration with current system.5 votes
We need to manage saved query version. Saved query management function includes comparing modified query with previous one.
We can't perceives any changing saved query and don't know which query version was run in a job. We'd like to know a person who changes query and modified points on the query.6 votes
On finding job what I execute manually, scheduled job is annoying.
How about filter schedule job and bulk import job?3 votes
Thanks for the feedback! There are some technical difficulties to make this happen, but we’ll see what we can do.
Let say we have table AAA without column aaa, then
'select aaa from AAA' get error like following.
Query 20150821_071516_06355_77wcr failed: Column 'aaa' cannot be resolved
When we issue SQL with retry 1, it immediately returns, but with retry 5 for example, we need to wait long time.
It is better for retry feature to understand what type of error need to handle with retry.
It is better syntax error returns immediately regardless of retry setting.3 votes
Investigating to determine feasibility & effort.
If we can change User Profile icon on Console, it is very helpful to see the list of users.
Also, account owner and administrator can change restricted-user's profile icon.2 votes
Thanks for the feedback! We are exploring this idea in our new release.
Query Result Preview showing 100 rows is very few.
It's useful to have Paging function as BigQuery console because most of users frequently check the first row and last row of the query result.6 votes
We are redesigning our console from the ground up. We will keep this suggestion in mind while doing so.
Send a notification from a browser when own job has finished.
Because sometimes I launch a huge job which take more than hour.
There are no way to know the job has finished or not without checking again and again at the job page.
There are very useful api for solve problem what I need.
Thanks for the suggestion! We are exploring some options that potentially solves this problem We’ll update you all when we have a plan.
Right now, the two location UDFs report slightly different names for some countries. Ones we've found are:
'United States of America' vs 'United States'
'South Korea' vs 'Republic of Korea'
'Hong Kong S.A.R.' vs 'Hong Kong'
Ideally, there should be a single standard at least within TD for full county names.5 votes
Reviewing feasibility based on the underlying data sources.
- Don't see your idea?