private async Task <FlowBlobOutputSpec> ProcessOutputBlob(string configName, FlowGuiOutput uiOutput) { if (uiOutput != null && uiOutput.Properties != null) { var sparkKeyVaultName = Configuration[Constants.ConfigSettingName_RuntimeKeyVaultName]; string connectionString = await KeyVaultClient.ResolveSecretUriAsync(uiOutput.Properties.ConnectionString); var accountName = ParseBlobAccountName(connectionString); var blobPath = $"wasbs://{uiOutput.Properties.ContainerName}@{accountName}.blob.core.windows.net/{uiOutput.Properties.BlobPrefix}/%1$tY/%1$tm/%1$td/%1$tH/${{quarterBucket}}/${{minuteBucket}}"; var secretId = $"{configName}-output"; var blobPathSecret = await KeyVaultClient.SaveSecretAsync(sparkKeyVaultName, secretId, blobPath, Configuration[Constants.ConfigSettingName_SparkType], true); await KeyVaultClient.SaveSecretAsync(sparkKeyVaultName, $"{Constants.AccountSecretPrefix}{accountName}", ParseBlobAccountKey(connectionString), Configuration[Constants.ConfigSettingName_SparkType], false); FlowBlobOutputSpec blobOutput = new FlowBlobOutputSpec() { CompressionType = uiOutput.Properties.CompressionType, Format = uiOutput.Properties.Format, Groups = new BlobOutputGroups() { Main = new BlobOutputMain() { Folder = blobPathSecret } } }; return(blobOutput); } else { return(null); } }
private async Task <FlowSqlOutputSpec> ProcessOutputSql(string configName, FlowGuiOutput uiOutput) { if (uiOutput != null && uiOutput.Properties != null) { var sparkKeyVaultName = Configuration[Constants.ConfigSettingName_RuntimeKeyVaultName]; string connectionString = await KeyVaultClient.ResolveSecretUriAsync(uiOutput.Properties.ConnectionString).ConfigureAwait(false); var database = GetValueFromJdbcConnection(connectionString, "database"); var user = GetValueFromJdbcConnection(connectionString, "user"); var pwd = GetValueFromJdbcConnection(connectionString, "password"); var url = GetUrlFromJdbcConnection(connectionString); var sparkType = Configuration.TryGet(Constants.ConfigSettingName_SparkType, out string value) ? value : null; // Save password and url in keyvault var pwdSecretId = $"{configName}-outSqlPassword"; var pwdRef = await KeyVaultClient.SaveSecretAsync(sparkKeyVaultName, pwdSecretId, pwd, sparkType, true).ConfigureAwait(false); var urlSecretId = $"{configName}-outSqlUrl"; var urlRef = await KeyVaultClient.SaveSecretAsync(sparkKeyVaultName, urlSecretId, url, sparkType, true).ConfigureAwait(false); FlowSqlOutputSpec sqlOutput = new FlowSqlOutputSpec() { ConnectionStringRef = uiOutput.Properties.ConnectionString, TableName = uiOutput.Properties.TableName, WriteMode = uiOutput.Properties.WriteMode, UseBulkInsert = uiOutput.Properties.UseBulkInsert, DatabaseName = database, User = user, Password = pwdRef, Url = urlRef }; return(sqlOutput); } else { return(null); } }
private async Task <FlowBlobOutputSpec> ProcessOutputBlob(string inputMode, string configName, FlowGuiOutput uiOutput) { if (uiOutput != null && uiOutput.Properties != null) { var sparkKeyVaultName = Configuration[Constants.ConfigSettingName_RuntimeKeyVaultName]; string connectionString = await KeyVaultClient.ResolveSecretUriAsync(uiOutput.Properties.ConnectionString).ConfigureAwait(false); var accountName = ConfigHelper.ParseBlobAccountName(connectionString); var timeFormat = ConfigHelper.GetBlobPartitionFormat(inputMode, uiOutput.Properties.BlobPartitionFormat); var blobPath = $"wasbs://{uiOutput.Properties.ContainerName}@{accountName}.blob.core.windows.net/{uiOutput.Properties.BlobPrefix}/{timeFormat}"; var secretId = $"{configName}-output"; var sparkType = Configuration.TryGet(Constants.ConfigSettingName_SparkType, out string value) ? value : null; var blobPathSecret = await KeyVaultClient.SaveSecretAsync(sparkKeyVaultName, secretId, blobPath, sparkType, true); await KeyVaultClient.SaveSecretAsync(sparkKeyVaultName, $"{Constants.AccountSecretPrefix}{accountName}", ConfigHelper.ParseBlobAccountKey(connectionString), sparkType, false); FlowBlobOutputSpec blobOutput = new FlowBlobOutputSpec() { CompressionType = uiOutput.Properties.CompressionType, Format = uiOutput.Properties.Format, Groups = new BlobOutputGroups() { Main = new BlobOutputMain() { Folder = blobPathSecret } } }; return(blobOutput); } else { return(null); } }