Allow copy stored procedures across datasets [150780188]

Assigned

Feature Request

Status Update

No update yet.

Description

be...@google.com

created issue #1

Mar 4, 2020 06:09PM

Please describe your requested enhancement. Good feature requests will solve common problems or enable new use cases.

What you would like to accomplish:
When copy datasets, it would be necessary to include stored procedures in this action.

How this might work:
It would be desired to include stored procedures when copy datasets.

If applicable, reasons why alternative solutions are not sufficient:
Currently, the copy task only supports tables and it's not possible to copy stored procedures with the Bigquery UI, BQ client and the API.

Other information (workarounds you have tried, documentation consulted, etc):
To copy a stored procedure, you can only do it manually.

Comments

be...@google.com <be...@google.com> #2Jun 8, 2020 10:32PM

[Deleted User] <[Deleted User]> #3Feb 1, 2021 01:53PM

[Deleted User] <[Deleted User]> #4Nov 23, 2021 02:42AM

ca...@dwd.wisconsin.gov <ca...@dwd.wisconsin.gov> #5Sep 1, 2022 03:55PM

Any update on this?

sv...@rewe-group.com <sv...@rewe-group.com> #6Sep 23, 2022 08:13AM

i would be interested in this update as well...

g....@ferryhopper.com <g....@ferryhopper.com> #7Dec 15, 2022 01:52PM

ne...@gmail.com <ne...@gmail.com> #8Jan 9, 2023 04:53PM

It would be helpful if stored procedures and functions are copied over when a dataset is copied. This is a behavior in other database systems - when you copy a database everything within it (tables, data, stored procedures, functions, triggers etc.) is copied as well.
In my case I created a template dataset, which is then used to roll out other client specific datasets. If this feature is implemented then copy dataset would take care of most of it (just need to update dataset reference within it). Currently, each function and stored procedures needs to be copied from one dataset and recreated in another one.

cr...@google.com <cr...@google.com> Jan 10, 2023 06:43PM

Reassigned to ja...@google.com.

ja...@google.com <ja...@google.com> May 31, 2023 09:05PM

Reassigned to ca...@google.com.

[Deleted User] <[Deleted User]> #9Jul 26, 2023 11:37AM

Hey is there, any update on this? I have written a python script to copy the routines but it only copies stored procedures and for some reason gives error on the other types.

ho...@gmail.com <ho...@gmail.com> #10Jan 3, 2024 03:43PM