BigQuery table updates

Options
Kyac
Kyac Registered Posts: 1 ✭✭✭

Hello,

Is there a way to change the BigQuery table of like 10 dataset on my flow or do i need to to do it one by one by changing the table name in dataset settings ?

Thanks in advance

Answers

  • gnaldi62
    gnaldi62 Partner, L2 Designer, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Frontrunner 2022 Participant, Neuron 2023 Posts: 79 Neuron
    Options

    Hi,

    I believe that once you have created the datasets with "static" names, the only chances are to either going to settings and change the name there (but be aware of what happens downwards) or either editing the recipe (if this is what is building the dataset) and change Input/Output (put you need to remove former datasets). There could be another alternatives which is to use a program to modify the settings using the DSS API.

    Unfortunately, it is not possible to define a name of a dataset using variables, otherwise this could have been an alternative; in other words, if one wanted to add a new dataset, its name could be specified as a variable. As said, this does work for datasets (when you create a new BQ connection you can specify the dataset, or schema, using a variable) but not for the names when you're asked to insert it (it can be done later...).
    Might be someone else is aware of an actual solution.

    Giuseppe

Setup Info
    Tags
      Help me…