[google-cloud-sql-discuss] Re: Beginner needing help

  I appreciate you sharing this. It was very helpful for my first project on Karl Jacobs shirts.

On Friday, January 7, 2022 at 3:06:43 AM UTC+5 wokmou wrote:

Aggregate Functions[1] will be a good start to help you summarizes the rows of a group into a single value. They return a single result row based on groups of rows, rather than on single rows.

[1] https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions

On Thursday, January 6, 2022 at 11:04:53 AM UTC-5 Michael Turnbull wrote:

Hi all, I'm new to this forum and just starting out on my SQL learnings in Google's Big Query. 

I have an issue where I'm trying to show data in a particular way based on multiple events. I'll try my best to explain my problem, and hopefully someone can help or offer advice. Thanks in advance. 

Problem statement - 

I'm trying to show when a customer (who has a unique identifier) has a series of job references booked over a period of 3 weeks, in order to show volume of repeat jobs for that customer. 

Example of what I have (trying to layout how I have the data in rows and columns)

Row 1 - (Column 1) = Week 1, (Column 2) = Customer 123, (Column 3) = Job ref 123

Row 2 - (Column 1) = Week 3, (Column 2) = Customer 123, (Column 3) = Job ref 345

I'd like to be able to simplify this view and show that over a 3 week period, that Customer 123 has had a repeat job ref against their unique customer number. 

I'd like it to almost show something like the below 

Row 1 - (Column 1) = Week of initial job, (Column 2) = Customer 123, Column 3 = count of first job in week 1, (Column 4) = Count of any repeat jobs in the weeks after week 1 occurred. 

Hopefully that makes sense, and this is my first time posting, so any further info needed then please ask. 

Thanks in advance for any help relating to my issue. 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/bdfb5070-40b1-4be2-bcae-17c1180d707fn%40googlegroups.com.

[google-cloud-sql-discuss] Re: Dataset is not found when saving a query

On my end, it is working properly so maybe it was a transient issue.

In any case, I can see from the Stackoverflow post that you manage to make it work by specifying the project as well.

Also, please remember that Groups is for general purpose discussions and as this issue is an unintended behavior, if anyone is still facing it, I recommend to create an issue report on issuetracker so the BigQuery engineering team can investigate it.

On Sunday, January 23, 2022 at 2:39:19 AM UTC+1 alid...@gmail.com wrote:

I am also face the same problem for city school sahiwal project. I hate to write queries.

On Friday, 21 January 2022 at 15:37:12 UTC+5 michael...@kenhallplumbers.com.au wrote:

I'm facing an issue when saving a query to a table into a specific dataset. 

I created a stackoverflow question. here is the link:

https://stackoverflow.com/questions/70796143/dataset-is-not-found-when-saving-a-query

Am I doing something wrong with my steps?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/1d1f4973-763f-4cf1-8cb3-29a9d21ac1d9n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Dataset is not found when saving a query

I am also face the same problem for city school sahiwal project. I hate to write queries.

On Friday, 21 January 2022 at 15:37:12 UTC+5 michael...@kenhallplumbers.com.au wrote:

I'm facing an issue when saving a query to a table into a specific dataset. 

I created a stackoverflow question. here is the link:

https://stackoverflow.com/questions/70796143/dataset-is-not-found-when-saving-a-query

Am I doing something wrong with my steps?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6cfe77a8-bd37-4e2c-b650-c59cbc193cbdn%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cloud SQL export to CSV then load to BigQuery

Thanks for sharing. I am checking this link it is really useful for paragon data.

On Friday, December 17, 2021 at 2:06:19 AM UTC+5 holoubi wrote:

We already support a null marker that should do the job for the user. See https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv#csv-options

On Thursday, December 16, 2021 at 10:49:44 AM UTC-5 tay...@aeris.net wrote:

Hi everyone

I am trying to export my data from Cloud SQL to CSV file storing in google cloud storage then load the file to BigQuery as external table.

The exporting is working well, the null value can be exported as "N or \N.

But seems like we don't have any null marker setting on BigQuery external table to tell BigQuery load the "N or \N to null value to my external table?

Thanks

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/0680d6f4-d9a0-4420-8b4f-8b0b87429210n%40googlegroups.com.

[google-cloud-sql-discuss] Dataset is not found when saving a query

I'm facing an issue when saving a query to a table into a specific dataset. 

I created a stackoverflow question. here is the link:

https://stackoverflow.com/questions/70796143/dataset-is-not-found-when-saving-a-query

Am I doing something wrong with my steps?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/847be0b0-27b6-4e21-a818-73f5cf162ebfn%40googlegroups.com.

[google-cloud-sql-discuss] Re: Cannot be connected Cloud SQL with Heroku

yeah, i am also facing the same issue for new projects like ranboo shirts. I am trying everything also read all documentation but I can't resolve my problem.

On Thursday, 13 January 2022 at 14:59:44 UTC+5 pand...@gmail.com wrote:

I have huge issue when I need deploy and connect my app to heroku and cloud sql native.

I have created my question on the link below

https://stackoverflow.com/questions/70690879/how-to-integrate-heroku-with-google-cloud-sql-native-gcp-in-nestjs-typeorm

Anyone who see this and response this, really appciate it. Really frustating now hfftt.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2fb868bb-5d20-4568-8fc0-a6659d0631d7n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Upgrade GCP hosted PostgreSQL while keeping existing user passwords

Hi,

I was searching for a way to migrate the users from one Cloud SQL instance to another, in this case a Cloud SQL Postgres 9.6 instance to a Cloud SQL Postgres 13, and I found this feature request.

If you think that feature would help you solve your issue I'd like to encourage you to write a message in that thread explaining your situation and how that feature would help you. 

As you can see here, users feedback is an important metric for feature requests. 

On Thursday 13 January 2022 at 10:59:52 UTC+1 henrik.s...@mindoktor.se wrote:

Did any of you manage to resolve this? I am in the same situation now and it doesn't look like a good solution exists. I am particularly concerned about the part about passwords. Some of the user accounts in the source database I need to migrate belonged to users who have left the company now. I don't know what their passwords were. Others are "machine" users, used by other parts of the company that I do not have access to. Getting hold of those passwords will require someone to sign off on my permission to do so, i.e. hoops to jump through. It feels a bit crazy that moving from postgres vX to vY on Google Cloud should be this complicated.

Just out of curiosity, do you know what will happen if I recreate the user accounts with the same name and permissions, but with different passwords? Will that work, or block the migration?

On Monday, 4 October 2021 at 10:43:49 UTC+2 davis...@gmail.com wrote:

My database for Lil Peep's rare merch suffers from the same problem. I have read all documentation, but cannot resolve the issue.

On Wednesday, 1 September 2021 at 12:37:09 UTC+5 jo...@vendohm.com wrote:

I have been tasked with upgrading our existing GCP hosted PostgreSQL databases from version 9.6 to version 13.

The instructions I found (https://cloud.google.com/sql/docs/postgres/upgrade-db)

say that we need to create a new database and then

"Make sure the target instance has... The same user accounts, with the same PostgreSQL privileges and passwords"

We have a number of databases with dozens of users and roles, we allow users to connect directly and set their own passwords.

We would like to perform the database upgrade without changing all the passwords.

I've looked at using pg_dumpall to copy the users to a new database, but it fails as I don't have permission to read pg_authid.

It seems that we need a superuser account to be able to read pg_authid, and GCP does not permit superuser accounts.

Is there any way to upgrade the databases and keep the existing passwords?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/551caa50-ad00-49cb-9bb8-0d06815cde45n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Upgrade GCP hosted PostgreSQL while keeping existing user passwords

Did any of you manage to resolve this? I am in the same situation now and it doesn't look like a good solution exists. I am particularly concerned about the part about passwords. Some of the user accounts in the source database I need to migrate belonged to users who have left the company now. I don't know what their passwords were. Others are "machine" users, used by other parts of the company that I do not have access to. Getting hold of those passwords will require someone to sign off on my permission to do so, i.e. hoops to jump through. It feels a bit crazy that moving from postgres vX to vY on Google Cloud should be this complicated.

Just out of curiosity, do you know what will happen if I recreate the user accounts with the same name and permissions, but with different passwords? Will that work, or block the migration?

On Monday, 4 October 2021 at 10:43:49 UTC+2 davis...@gmail.com wrote:

My database for Lil Peep's rare merch suffers from the same problem. I have read all documentation, but cannot resolve the issue.

On Wednesday, 1 September 2021 at 12:37:09 UTC+5 jo...@vendohm.com wrote:

I have been tasked with upgrading our existing GCP hosted PostgreSQL databases from version 9.6 to version 13.

The instructions I found (https://cloud.google.com/sql/docs/postgres/upgrade-db)

say that we need to create a new database and then

"Make sure the target instance has... The same user accounts, with the same PostgreSQL privileges and passwords"

We have a number of databases with dozens of users and roles, we allow users to connect directly and set their own passwords.

We would like to perform the database upgrade without changing all the passwords.

I've looked at using pg_dumpall to copy the users to a new database, but it fails as I don't have permission to read pg_authid.

It seems that we need a superuser account to be able to read pg_authid, and GCP does not permit superuser accounts.

Is there any way to upgrade the databases and keep the existing passwords?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/5b550a6b-6cb3-4829-bfbd-b643b84861c8n%40googlegroups.com.

[google-cloud-sql-discuss] Cannot be connected Cloud SQL with Heroku

I have huge issue when I need deploy and connect my app to heroku and cloud sql native.

I have created my question on the link below

https://stackoverflow.com/questions/70690879/how-to-integrate-heroku-with-google-cloud-sql-native-gcp-in-nestjs-typeorm

Anyone who see this and response this, really appciate it. Really frustating now hfftt.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fc891a2b-29fe-4f25-af01-7706337068f2n%40googlegroups.com.

Re: [google-cloud-sql-discuss] Re: When will Database Migration Service support PostgreSQL 14?

Hello,

Talking about specific use cases is a little outside the scope of Groups, and upgrading a database while limiting downtime is complicated with many dimensions. The best strategy is the safest and most direct path to major version upgrading, especially for mission critical instances. Granted DMS abstracts alot of the work away even then, there are still many things to consider. Having said that, I would recommend opening up a ticket with support for the benefit of their introspection, and due diligence.

On Tuesday, January 11, 2022 at 10:57:56 AM UTC-5 Pijush Chatterjee wrote:

Hello All,

My client New York Times has a similar request, they wanted to upgrade their 350 GB postgres instance from v12 to v14. I suggested DMS, but as v14.0 is not available.. what would be the alternate best strategy for them to upgrade the db with minimal downtime?

Thanks,

Pijush Chatterjee Customer Engineer pijus...@google.com 773-456-8851

On Mon, Jan 10, 2022 at 5:12 PM 'darrel...@google.com' via Google Cloud SQL discuss <google-cloud...@googlegroups.com> wrote:

Hi,

At this moment, we do not have an ETA for postgres 14 availability for DMS. You can check the DMS "Release Notes" page[1] for updates.

I suggest opening a feature request on Google's issuetracker[2] as the product team have visibility on that platform.

[1] https://cloud.google.com/database-migration/docs/release-notes

[2] https://cloud.google.com/support/docs/issue-trackers

On Monday, January 10, 2022 at 8:13:07 AM UTC-5 daniel.ale...@gmail.com wrote:

As of December 15, 2021, Cloud SQL for PostgreSQL supports PostgreSQL major version 14 (see https://cloud.google.com/sql/docs/release-notes#December_15_2021).

However, Cloud DMS still only supports PostgreSQL up to major version 13 (see https://cloud.google.com/database-migration/docs/postgres/migration-src-and-dest). And I can indeed only select up to version 13 when creating a migration.

What are the plans to roll out support for PostgreSQL 14 to Cloud DMS?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9f82c9bf-88e5-4d19-8863-33bca57fef12n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a1ecfea9-1302-451f-8da6-7468f4a11d33n%40googlegroups.com.

Re: [google-cloud-sql-discuss] Re: When will Database Migration Service support PostgreSQL 14?

Hello All,

My client New York Times has a similar request, they wanted to upgrade their 350 GB postgres instance from v12 to v14. I suggested DMS, but as v14.0 is not available.. what would be the alternate best strategy for them to upgrade the db with minimal downtime?

Thanks,

Pijush Chatterjee Customer Engineer pijushchatt@google.com 773-456-8851

On Mon, Jan 10, 2022 at 5:12 PM 'darrelldavid@google.com' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:

Hi,

At this moment, we do not have an ETA for postgres 14 availability for DMS. You can check the DMS "Release Notes" page[1] for updates.

I suggest opening a feature request on Google's issuetracker[2] as the product team have visibility on that platform.

[1] https://cloud.google.com/database-migration/docs/release-notes

[2] https://cloud.google.com/support/docs/issue-trackers

On Monday, January 10, 2022 at 8:13:07 AM UTC-5 daniel.ale...@gmail.com wrote:

As of December 15, 2021, Cloud SQL for PostgreSQL supports PostgreSQL major version 14 (see https://cloud.google.com/sql/docs/release-notes#December_15_2021).

However, Cloud DMS still only supports PostgreSQL up to major version 13 (see https://cloud.google.com/database-migration/docs/postgres/migration-src-and-dest). And I can indeed only select up to version 13 when creating a migration.

What are the plans to roll out support for PostgreSQL 14 to Cloud DMS?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9f82c9bf-88e5-4d19-8863-33bca57fef12n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CALf5%3DWnWqkP81kSVGyVtuxVOgDM1_LJruWiGk-HiSNFuRzO9_w%40mail.gmail.com.

[google-cloud-sql-discuss] Re: When will Database Migration Service support PostgreSQL 14?

Hi,

At this moment, we do not have an ETA for postgres 14 availability for DMS. You can check the DMS "Release Notes" page[1] for updates.

I suggest opening a feature request on Google's issuetracker[2] as the product team have visibility on that platform.

[1] https://cloud.google.com/database-migration/docs/release-notes

[2] https://cloud.google.com/support/docs/issue-trackers

On Monday, January 10, 2022 at 8:13:07 AM UTC-5 daniel.ale...@gmail.com wrote:

As of December 15, 2021, Cloud SQL for PostgreSQL supports PostgreSQL major version 14 (see https://cloud.google.com/sql/docs/release-notes#December_15_2021).

However, Cloud DMS still only supports PostgreSQL up to major version 13 (see https://cloud.google.com/database-migration/docs/postgres/migration-src-and-dest). And I can indeed only select up to version 13 when creating a migration.

What are the plans to roll out support for PostgreSQL 14 to Cloud DMS?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9f82c9bf-88e5-4d19-8863-33bca57fef12n%40googlegroups.com.

[google-cloud-sql-discuss] Re: [cloud_sql_proxy] running permanently as a windows service

Hi,

As the question related directly to third party tools, Google would never endorse one product over another. A simple Google search does offer some options with NSSM seeming to be a favorite on this popular Stackoverflow thread.

On Sunday, January 9, 2022 at 2:51:52 PM UTC-5 shaunm...@gmail.com wrote:

I am also facing the same issue for my old project karl jacobs accessories. It is imperative that I get a solution so that my project can run smoothly.

On Tuesday, 23 November 2021 at 23:07:41 UTC+5 Lyka Segura wrote:

Hi all,

IHAC who wants to run the cloud auth proxy as a windows service. The issue is they are unable to use third party libraries to do it (https://nssm.cc/) so wanted to check if there's a way to do it without the use of mentioned third party libraries?

Thanks in advance! 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/762eb23e-5bc0-47fb-b213-a9c6c551f1f4n%40googlegroups.com.

[google-cloud-sql-discuss] When will Database Migration Service support PostgreSQL 14?

As of December 15, 2021, Cloud SQL for PostgreSQL supports PostgreSQL major version 14 (see https://cloud.google.com/sql/docs/release-notes#December_15_2021).

However, Cloud DMS still only supports PostgreSQL up to major version 13 (see https://cloud.google.com/database-migration/docs/postgres/migration-src-and-dest). And I can indeed only select up to version 13 when creating a migration.

What are the plans to roll out support for PostgreSQL 14 to Cloud DMS?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9e61e78b-f06c-4fa2-9c7e-29c95eaa03e3n%40googlegroups.com.

[google-cloud-sql-discuss] Re: [cloud_sql_proxy] running permanently as a windows service

I am also facing the same issue for my old project karl jacobs accessories. It is imperative that I get a solution so that my project can run smoothly.

On Tuesday, 23 November 2021 at 23:07:41 UTC+5 Lyka Segura wrote:

Hi all,

IHAC who wants to run the cloud auth proxy as a windows service. The issue is they are unable to use third party libraries to do it (https://nssm.cc/) so wanted to check if there's a way to do it without the use of mentioned third party libraries?

Thanks in advance! 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/7775c5f2-94db-41d4-94f0-fb0e90ea583an%40googlegroups.com.

[google-cloud-sql-discuss] Re: Beginner needing help

Aggregate Functions[1] will be a good start to help you summarizes the rows of a group into a single value. They return a single result row based on groups of rows, rather than on single rows.

[1] https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions

On Thursday, January 6, 2022 at 11:04:53 AM UTC-5 Michael Turnbull wrote:

Hi all, I'm new to this forum and just starting out on my SQL learnings in Google's Big Query. 

I have an issue where I'm trying to show data in a particular way based on multiple events. I'll try my best to explain my problem, and hopefully someone can help or offer advice. Thanks in advance. 

Problem statement - 

I'm trying to show when a customer (who has a unique identifier) has a series of job references booked over a period of 3 weeks, in order to show volume of repeat jobs for that customer. 

Example of what I have (trying to layout how I have the data in rows and columns)

Row 1 - (Column 1) = Week 1, (Column 2) = Customer 123, (Column 3) = Job ref 123

Row 2 - (Column 1) = Week 3, (Column 2) = Customer 123, (Column 3) = Job ref 345

I'd like to be able to simplify this view and show that over a 3 week period, that Customer 123 has had a repeat job ref against their unique customer number. 

I'd like it to almost show something like the below 

Row 1 - (Column 1) = Week of initial job, (Column 2) = Customer 123, Column 3 = count of first job in week 1, (Column 4) = Count of any repeat jobs in the weeks after week 1 occurred. 

Hopefully that makes sense, and this is my first time posting, so any further info needed then please ask. 

Thanks in advance for any help relating to my issue. 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/dbeac0c8-df90-4daf-87ca-f11f7bfba030n%40googlegroups.com.

[google-cloud-sql-discuss] Beginner needing help

Hi all, I'm new to this forum and just starting out on my SQL learnings in Google's Big Query. 

I have an issue where I'm trying to show data in a particular way based on multiple events. I'll try my best to explain my problem, and hopefully someone can help or offer advice. Thanks in advance. 

Problem statement - 

I'm trying to show when a customer (who has a unique identifier) has a series of job references booked over a period of 3 weeks, in order to show volume of repeat jobs for that customer. 

Example of what I have (trying to layout how I have the data in rows and columns)

Row 1 - (Column 1) = Week 1, (Column 2) = Customer 123, (Column 3) = Job ref 123

Row 2 - (Column 1) = Week 3, (Column 2) = Customer 123, (Column 3) = Job ref 345

I'd like to be able to simplify this view and show that over a 3 week period, that Customer 123 has had a repeat job ref against their unique customer number. 

I'd like it to almost show something like the below 

Row 1 - (Column 1) = Week of initial job, (Column 2) = Customer 123, Column 3 = count of first job in week 1, (Column 4) = Count of any repeat jobs in the weeks after week 1 occurred. 

Hopefully that makes sense, and this is my first time posting, so any further info needed then please ask. 

Thanks in advance for any help relating to my issue. 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3e077840-ac77-468a-b5cd-79e22d2fb219n%40googlegroups.com.

[google-cloud-sql-discuss] Re: Data Migration cloud SQL in one project to another

Hello,

If the issue persists, I recommend you submit a question on stackoverflow[1]; or if you have the Premium Support you can create a ticket; and provide us with the full details of the Issue so that we would be able to provide you with the most appropriate answer.

Note that, Google Cloud Platform Groups are for general questions and discussions about GCP-end products and for reporting specific issues you should raise a ticket in the Issue Tracker[2].

[1] https://stackoverflow.com/questions/tagged/google-cloud-platform
[2] https://cloud.google.com/support/docs/issue-trackers 

On Tuesday, January 4, 2022 at 5:08:57 PM UTC-5 diriv...@teamapt.com wrote:

Hello,

Please can anyone help with if it is possible Cloud SQL data migration from one project to another.

I have tried so many times and it keeps failing when transitioning to CDC with error:

Migration job new-db status changed from RUNNING, CDC in progress to FAILED, during CDC. Failure due to the following error: error code: 0, error message: error connecting to master 'root@:3306' - retry-time: 60 retries: 1 message: Access denied for user 'root'@'' (using password: YES)
kind regards

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/53bdd500-3488-4008-b087-02c0bdbcebaen%40googlegroups.com.

[google-cloud-sql-discuss] Data Migration cloud SQL in one project to another

Hello,

Please can anyone help with if it is possible Cloud SQL data migration from one project to another.

I have tried so many times and it keeps failing when transitioning to CDC with error:

Migration job new-db status changed from RUNNING, CDC in progress to FAILED, during CDC. Failure due to the following error: error code: 0, error message: error connecting to master 'root@:3306' - retry-time: 60 retries: 1 message: Access denied for user 'root'@'' (using password: YES)
kind regards

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/af50583b-6830-464a-adac-1d40f455c7aan%40googlegroups.com.