initialization-actions
initialization-actions copied to clipboard
Fixing cloud-sql-proxy.sh
Fix the script to adopt two scenarios:
- No source list file needs to be updated
- Multiple source list files need to be updated
/gcbrun
That looks like a good idea
Tested manually in:
- 2.2-debian12 ✅
- 2.1-debian11 ✅
- 2.0-debian10 ✅
- 1.5-debian10 ✅
- 2.2-rocky9 ✅
- 2.1-rocky8 ✅
- 2.0-rocky8 ✅
I used these metadata to configure hive:
--initialization-actions "${INIT_ACTIONS_ROOT}/cloud-sql-proxy/cloud-sql-proxy.sh" \
--properties "hive:hive.metastore.warehouse.dir=gs://${HIVE_DATA_BUCKET}/hive-warehouse" \
--metadata "hive-metastore-instance=${PROJECT_ID}:${REGION}:${HIVE_INSTANCE_NAME}" \
--metadata "db-hive-password-uri=gs://${BUCKET}/dataproc-initialization-actions/mysql_hive_password.encrypted" \
--metadata "kms-key-uri=projects/${PROJECT_ID}/locations/global/keyRings/KEYRING/cryptoKeys/KEYNAME" \