C# How to get Glue connection object

[dburtsev]

Hello all
In PowerShell, I can get the connection object
[Amazon.Glue.Model.Connection]$jdbcon = Get-GLUEConnection -Name $ConnectionName
How can I do the same in C# ?
Thanks

[ashishdhingra]

Assuming you are using .NET 6, below code should work (you would need to add reference to AWSSDK.Glue NuGet package):

using Amazon.Glue;
using Amazon.Glue.Model;

var client = new AmazonGlueClient();
var request = new GetConnectionRequest() { Name = "<<connection-name>>" };
var response = await client.GetConnectionAsync(request);

Thanks,
Ashish

[dburtsev]

Thanks @ashishdhingra
How can I return Amazon.Glue.Model.Connection from proc?

        private static async Task<Amazon.Glue.Model.Connection> GetConnectionObj(string ConnName)
        {
            var client = new AmazonGlueClient();
            var request = new GetConnectionRequest() { Name = ConnName };
            var response = await client.GetConnectionAsync(request);
            return response.ConnectionList[0];
        }

'GetConnectionResponse' does not contain a definition for 'ConnectionList' and no accessible extension method 'ConnectionList' accepting a first argument of type 'GetConnectionResponse' could be found

[dburtsev]

Amazon.Glue.Model.Connection jdbcon = GetConnectionObj(ConnectionName);
Console.WriteLine(jdbcon.ConnectionProperties["JDBC_CONNECTION_URL"]);

        private static async Task<Amazon.Glue.Model.Connection> GetConnectionObjasync(string ConnName)
        {
            var client = new AmazonGlueClient();
            var request = new GetConnectionRequest() { Name = ConnName };
            var response = await client.GetConnectionAsync(request);
            return response.Connection;// .ConnectionList[0];
        }
        private static Amazon.Glue.Model.Connection GetConnectionObj(string ConnName)
        {
            var task = GetConnectionObjasync(ConnName);
            task.Wait();
            return task.Result;            
        }

It works. Thank you.

[github-actions[bot]]

Hello! Reopening this discussion to make it searchable.