SNOW-781549: Add DataFrame.getColumns()

[sfc-gh-jfreeberg]

Add a method to the DataFrame class, .getColumns() which returns a List<Column> of the dataframe's column names.

[sbouhaddi]

Can i take a look at this one?

[sfc-gh-jfreeberg]

@sbouhaddi -- Yeah absolutely! Check CONTRIBUTING.md for some instructions on setting up your local environment. Ping @sfc-gh-bli or me if you have any questions.

[sbouhaddi]

Can you assign it to me please?
Thank you

[mfirry]

Hi, new here: can something like def getColumns(): Seq[Column] = df.schema.fields.map(f => Column(f.columnIdentifier.name)).toSeq work?

[sbouhaddi]

Hello,
I didn't look at it yet.
Planning to do it this weekend, i will try your solution and let you know thank you

[sfc-gh-jfreeberg]

Thanks for taking a look @mfirry and @sbouhaddi ! Tag me here if you have any questions

[sbouhaddi]

@sfc-gh-jfreeberg
It's not mentioned in the issue description , should this modification impact the java class , the scala one or both.
Can you please share that info with me
Thanks

[sbouhaddi]

@sfc-gh-jfreeberg
Should i install or do something locally to make the project work ?
I created a snowflake account but i d'ont think that was enough
I'm having this exception
**net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connection reset.**

When i execute

mvn -DtagsToExclude=com.snowflake.snowpark.UDFTest -Dgpg.skip scoverage:report

[sfc-gh-jfreeberg]

@sbouhaddi -- This should be support for both the Java and Scala classes. I'd recommend implementing it on the Scala class, then importing and adding a wrapper around the Java method (if you browse the Java DataFrame class you'll see a similar pattern).

As for the build problem, which JDK do you have installed locally?

[sfc-gh-jfreeberg]

@sbouhaddi -- Any luck?

[sbouhaddi]

@sfc-gh-jfreeberg Sorry i was a bit busy last week.
I will look at it this week hopefully.

[sbouhaddi]

it's my first time with scala , i'm willing to learn and finish this issue .
But i'm needing some help and guidance if someone can provide it

[mfirry]

@sfc-gh-jfreeberg ?

[sfc-gh-wfateem]

@sbouhaddi That error indicates that there's likely a firewall or proxy blocking your connection to the snowflakecomputing.com host:

 **net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connection reset.**

You need to be able to run the following query in Snowflake to identify which hosts and ports you need to open up traffic to and from:
select system$allowlist()

But if you're unable to connect to the *.snowflakecomputing.com host from your own machine then you're unlikely going to be able to access it using a browser either.