Results for "schema"
7 / 184 posts
Find column in the whole database in sql server
To find a specific column in the whole database in SQL Server, you can query the information schema views. Here's a query you can use: SELECT table_name, c…
How to Read and Write file into DataFrame by using Pyspark
# dataframe reader API.... spark.read.format("") \ .option("key":"value") \ .schema(schemavariable) \ .load() # dataframe write API...... spark.write.mode(…
SYS and INFORMATION_SCHEMA
sys In Microsoft SQL Server, the sys schema is a special schema that contains system views and stored procedures that provide metadata about the SQL Server…
Schema and Handling Corrupt data in PySpark
A schema in PySpark (and generally in data processing) defines the structure of a DataFrame, including the names and data types of each column. It serves a…
Database trigger to audit (Transaction logs) all of the DDL changes made to the Database
Create table DatabaseLog: CREATE TABLE [dbo].[DatabaseLog]( [DatabaseLogID] [int] IDENTITY(1,1) NOT NULL, [PostTime] [datetim…
⭐ Star Schema vs ❄ Snowflake Schema – Data Warehouse Modeling
⭐ Star Schema Kya Hota Hai? Star Schema ek simple aur sabse popular data warehouse model hai. Isme: Beech me hoti hai 👉 Fact Table Uske around hoti hain �…
What Is Dimensional Modeling in Data Warehouse?
Before going deep into Star Schema and Fact Tables, pehle ek basic sawal: Dimensional Modeling hota kya hai? Dimensional Modeling ek technique hai jo Data …