Datavalley Community

2

CalvinExplainer

Asked: July 7, 2023In: Data Engineering

Error when establishing connection with SQL server.

2

I’m getting the following error in jenkins: Error extracting database:Could not connect to database server. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was ...

1

AdithyaPundit

Asked: July 6, 2023In: Data Engineering

How to block users from editing a table in PostgreSQL?

1

I want to block users from editing the table like adding or deleting rows or columns from the table. Please mention how to restore those user privileges later.

2

MeetPundit

Asked: July 4, 2023In: Power BI

Does Power BI have a LEAD() function?

2

Does power BI have a LEAD() function similar to SQL? Since they can refer to data from rows above or below the current row, lead functions are extremely handy for constructing reports.

6

dishachExplainer

Asked: June 27, 2023In: Data Engineering

Pyspark equivalent code to the Databricks SQL code

6

I want to create a dataframe from the databricks SQL code given below. But I need to write it in Pyspark. What will be the Pyspark code for this? CREATE OR REPLACE VIEW monthview AS SELECT last_day(add_months(current_date(),-1))

5

PeggyProfessional

Asked: June 27, 2023In: Data Engineering

How can I Install pgAgent on Postgres Alpine?

5

I’m having a Postgres container that uses Postgres alpine as its base image. On this base image, I would like to install pgAgent. How to do that? I have attempted to install the source code within the container ...