YAMAMORI, Akihiro gecko655
π
gecko655
/ uniontest.sql
Created
June 23, 2020 03:43
BigQuery union behavior with different column definition
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create table `uniontest.uniontest_1` | |
| (partition_key date, cluster_key string, hoge string) | |
| partition by partition_key | |
| cluster by cluster_key | |
| as select cast('2020-06-22' as date), 'a', 'b'; | |
| create table `uniontest.uniontest_2` | |
| (partition_key date, cluster_key string, piyo string) | |
| partition by partition_key | |
| cluster by cluster_key |
gecko655
/ debug_log_for_terraform-provider-google_8579.txt
Last active
March 1, 2021 06:11
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2021-02-26T12:43:08.637+0900 [INFO] plugin: configuring client automatic mTLS | |
| 2021-02-26T12:43:08.656+0900 [DEBUG] plugin: starting plugin: path=.terraform/providers/registry.terraform.io/hashicorp/google/3.52.0/darwin_amd64/terraform-provider-google_v3.52.0_x5 args=[.terraform/providers/registry.terraform.io/hashicorp/google/3.52.0/darwin_amd64/terraform-provider-google_v3.52.0_x5] | |
| 2021-02-26T12:43:08.667+0900 [DEBUG] plugin: plugin started: path=.terraform/providers/registry.terraform.io/hashicorp/google/3.52.0/darwin_amd64/terraform-provider-google_v3.52.0_x5 pid=30310 | |
| 2021-02-26T12:43:08.667+0900 [DEBUG] plugin: waiting for RPC address: path=.terraform/providers/registry.terraform.io/hashicorp/google/3.52.0/darwin_amd64/terraform-provider-google_v3.52.0_x5 | |
| 2021-02-26T12:43:08.684+0900 [INFO] plugin.terraform-provider-google_v3.52.0_x5: configuring server automatic mTLS: timestamp=2021-02-26T12:43:08.684+0900 | |
| 2021-02-26T12:43:08.704+0900 [DEBUG] plugin.terraform-provider-google_v3.52.0_x5: plugin address |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| _ "embed" | |
| "fmt" | |
| "strings" | |
| ) | |
| //go:embed test.txt | |
| var Content []byte |
gecko655
/ DataflowTemplates_build_fails_command.sh
Last active
December 21, 2021 08:36
https://github.com/GoogleCloudPlatform/DataflowTemplates build fails
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| git clone [email protected]:GoogleCloudPlatform/DataflowTemplates.git DataflowTemplates | |
| cd DataflowTemplates/v2 | |
| git rev-parse HEAD | |
| # -> 68e6939d82e1ad84aa69f33e59c74d6bdea89a3e | |
| docker run --rm -v $(pwd):/root --entrypoint=bash gcr.io/cloud-builders/mvn@sha256:d2142eae8adb79128665fdfb2953cb3135ef83b9f21c3d113273bc8907c88bdf \ | |
| -c "cd /root && mvn clean test --batch-mode \ | |
| -Dimage=gcr.io/hoge/piyo \ | |
| -Dbase-container-image='gcr.io/dataflow-templates-base/java8-template-launcher-base' \ | |
| -Dbase-container-image.version=latest \ | |
| -Dapp-root=/template/pubsub-cdc-to-bigquery \ |
gecko655
/ terraform_apply_google_cloudbuild_worker_pool.txt
Last active
March 1, 2022 04:42
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| β― TF_LOG=DEBUG terraform apply | |
| 2022-03-01T13:37:25.519+0900 [INFO] Terraform version: 1.1.6 | |
| 2022-03-01T13:37:25.519+0900 [INFO] Go runtime version: go1.17.2 | |
| 2022-03-01T13:37:25.519+0900 [INFO] CLI args: []string{"/Users/[user_name]/.asdf/installs/terraform/1.1.6/bin/terraform", "apply"} | |
| 2022-03-01T13:37:25.520+0900 [DEBUG] Attempting to open CLI config file: /Users/[user_name]/.terraformrc | |
| 2022-03-01T13:37:25.520+0900 [DEBUG] File doesn't exist, but doesn't need to. Ignoring. | |
| 2022-03-01T13:37:25.523+0900 [DEBUG] checking for credentials in "/Users/[user_name]/.terraform.d/plugins" | |
| 2022-03-01T13:37:25.523+0900 [DEBUG] checking for credentials in "/Users/[user_name]/.terraform.d/plugins/darwin_amd64" | |
| 2022-03-01T13:37:25.524+0900 [DEBUG] ignoring non-existing provider search directory terraform.d/plugins | |
| 2022-03-01T13:37:25.524+0900 [DEBUG] will search for provider plugins in /Users/[user_name]/.terraform.d/plugins |
gecko655
/ extract_excel_external_links.bash
Last active
September 5, 2024 08:05
extract_excel_external_links.bash
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| main() { | |
| target_file_glob="${1}" | |
| tmpdir="${2}" | |
| for target_file in $target_file_glob; do | |
| # γγ‘γ€γ«εγ« ~ γε«γγ§γγγγΉγγγ | |
| if [[ $target_file == *~* ]]; then | |
| continue | |
| fi |
OlderNewer