Results for "file"
8 / 184 posts
Azure Databricks command
Here are some common commands used in Databricks: %fs : Allows you to interact with the filesystem. For example, %fs ls lists the files in the current dire…
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(…
How to Read and Write CSV file into DataFrame by using Pyspark
PySpark Read CSV File into DataFrame: reading CSV files from disk using PySpark offers a versatile and efficient approach to data ingestion and processing.…
What are System Tables, File Tables, External Tables and Graph Tables in SQL Server
1. System Tables Definition : System tables are internal tables used by SQL Server to store information about the database and server itself. These are met…
Data Import from text/CSV file in SQL Server
Step-by-Step Explanation 1. Checking and Dropping Existing Temporary Tables Before creating the temporary tables, the script ensures that any previously ex…
File Handling(create, read, write, and delete files etc.)
File Handling in Python allows us to create, read, write, and delete files . It's an essential feature when working with data that needs to be stored perma…
MDF, NDF, LDF, and Filegroups
🔹 1. Filegroup kya hota hai? 🔸 Definition: Filegroup SQL Server में logical storage unit hota hai, jisme ek ya zyada data files hoti hain. Ye filegroups …
Database Shrink in SQL Server
Database shrink ka matlab hai database file (ya log file) ke size ko chhota karna by removing unused space . Matlab, agar tumhare DB me data delete ho gaya…