#fabric lakehouse

[ibarrau]

[Fabric] Entre Archivos y Tablas de Lakehouse - SQL Notebooks

Ya conocemos un panorama de Fabric y por donde empezar. La Data Web nos mostró unos artículos sobre esto. Mientras más veo Fabric más sorprendido estoy sobre la capacidad SaaS y low code que generaron para todas sus estapas de proyecto.

Un ejemplo sobre la sencillez fue copiar datos con Data Factory. En este artículo veremos otro ejemplo para que fanáticos de SQL puedan trabajar en ingeniería de datos o modelado dimensional desde un notebook.

Arquitectura Medallón

Si nunca escuchaste hablar de ella te sugiero que pronto leas. La arquitectura es una metodología que describe una capas de datos que denotan la calidad de los datos almacenados en el lakehouse. Las capas son carpetas jerárquicas que nos permiten determinar un orden en el ciclo de vida del datos y su proceso de transformaciones.

Los términos bronce (sin procesar), plata (validado) y oro (enriquecido/agrupado) describen la calidad de los datos en cada una de estas capas.

Ésta metodología es una referencia o modo de trabajo que puede tener sus variaciones dependiendo del negocio. Por ejemplo, en un escenario sencillo de pocos datos, probablemente no usaríamos gold, sino que luego de dejar validados los datos en silver podríamos construir el modelado dimensional directamente en el paso a "Tablas" de Lakehouse de Fabric.

NOTAS: Recordemos que "Tablas" en Lakehouse es un spark catalog también conocido como Metastore que esta directamente vinculado con SQL Endpoint y un PowerBi Dataset que viene por defecto.

¿Qué son los notebooks de Fabric?

Microsoft los define como: "un elemento de código principal para desarrollar trabajos de Apache Spark y experimentos de aprendizaje automático, es una superficie interactiva basada en web que usan los científicos de datos e ingenieros de datos para escribir un código que se beneficie de visualizaciones enriquecidas y texto en Markdown."

Dicho de manera más sencilla, es un espacio que nos permite ejecutar bloques de código spark que puede ser automatizado. Hoy por hoy es una de las formas más populares para hacer transformaciones y limpieza de datos.

Luego de crear un notebook (dentro de servicio data engineering o data science) podemos abrir en el panel izquierdo un Lakehouse para tener referencia de la estructura en la cual estamos trabajando y el tipo de Spark deseado.

Spark

Spark se ha convertido en el indiscutible lenguaje de lectura de datos en un lake. Así como SQL lo fue por años sobre un motor de base de datos, ahora Spark lo es para Lakehouse. Lo bueno de spark es que permite usar más de un lenguaje según nuestro comodidad.

Creo que es inegable que python está ocupando un lugar privilegiado junto a SQL que ha ganado suficiente popularidad como para encontrarse con ingenieros de datos que no conocen SQL pero son increíbles desarrolladores en python. En este artículo quiero enfocarlo en SQL puesto que lo más frecuente de uso es Python y podríamos charlar de SQL para aportar a perfiles más antiguos como DBAs o Data Analysts que trabajaron con herramientas de diseño y Bases de Datos.

Lectura de archivos de Lakehouse con SQL

Lo primero que debemos saber es que para trabajar en comodidad con notebooks, creamos tablas temporales que nacen de un esquema especificado al momento de leer la información. Para el ejemplo veremos dos escenarios, una tabla Customers con un archivo parquet y una tabla Orders que fue particionada por año en distintos archivos parquet según el año.

CREATE OR REPLACE TEMPORARY VIEW Dim_Customers_Temp USING PARQUET OPTIONS ( path "Files/Silver/Customers/*.parquet", header "true", mode "FAILFAST" ) ;

CREATE OR REPLACE TEMPORARY VIEW Orders USING PARQUET OPTIONS ( path "Files/Silver/Orders/Year=*", header "true", mode "FAILFAST" ) ;

Vean como delimitamos la tabla temporal, especificando el formato parquet y una dirección super sencilla de Files. El "*" nos ayuda a leer todos los archivos de una carpeta o inclusive parte del nombre de las carpetas que componen los archivos. Para el caso de orders tengo carpetas "Year=1998" que podemos leerlas juntas reemplazando el año por asterisco. Finalmente, especificamos que tenga cabeceras y falle rápido en caso de un problema.

Consultas y transformaciones

Una vez creada la tabla temporal, podremos ejecutar en la celda de un notebook una consulta como si estuvieramos en un motor de nuestra comodidad como DBeaver.

Escritura de tablas temporales a las Tablas de Lakehouse

Realizadas las transformaciones, joins y lo que fuera necesario para construir nuestro modelado dimensional, hechos y dimensiones, pasaremos a almacenarlo en "Tablas".

Las transformaciones pueden irse guardando en otras tablas temporales o podemos almacenar el resultado de la consulta directamente sobre Tablas. Por ejemplo, queremos crear una tabla de hechos Orders a partir de Orders y Order details:

CREATE TABLE Fact_Orders USING delta AS SELECT od.*, o.CustomerID, o.EmployeeID, o.OrderDate, o.Freight, o.ShipName FROM OrdersDetails od LEFT JOIN Orders o ON od.OrderID = o.OrderID

Al realizar el Create Table estamos oficialmente almacenando sobre el Spark Catalog. Fíjense el tipo de almacenamiento porque es muy importante que este en DELTA para mejor funcionamiento puesto que es nativo para Fabric.

Resultado

Si nuestro proceso fue correcto, veremos la tabla en la carpeta Tables con una flechita hacia arriba sobre la tabla. Esto significa que la tabla es Delta y todo está en orden. Si hubieramos tenido una complicación, se crearía una carpeta "Undefinied" en Tables la cual impide la lectura de nuevas tablas y transformaciones por SQL Endpoint y Dataset. Mucho cuidado y siempre revisar que todo quede en orden:

Pensamientos

Así llegamos al final del recorrido donde podemos apreciar lo sencillo que es leer, transformar y almacenar nuestros modelos dimensionales con SQL usando Notebooks en Fabric. Cabe aclarar que es un simple ejemplo sin actualizaciones incrementales pero si con lectura de particiones de tiempo ya creadas por un data engineering en capa Silver.

¿Qué hay de Databricks?

Podemos usar libremente databricks para todo lo que sean notebooks y procesamiento tal cual lo venimos usando. Lo que no tendríamos al trabajar de ésta manera sería la sencillez para leer y escribir tablas sin tener que especificar todo el ABFS y la característica de Data Wrangler. Dependerá del poder de procesamiento que necesitamos para ejecutar el notebooks si nos alcanza con el de Fabric o necesitamos algo particular de mayor potencia. Para más información pueden leer esto: https://learn.microsoft.com/en-us/fabric/onelake/onelake-azure-databricks

Espero que esto los ayude a introducirse en la construcción de modelados dimensionales con clásico SQL en un Lakehouse como alternativa al tradicional Warehouse usando Fabric. Pueden encontrar el notebook completo en mi github que incluye correr una celda en otro lenguaje y construcción de tabla fecha en notebook.

[rajaniesh]

Unveiling the Power of Delta Lake in Microsoft Fabric

Discover how Microsoft Fabric and Delta Lake can revolutionize your data management and analytics. Learn to optimize data ingestion with Spark and unlock the full potential of your data for smarter decision-making.

In today’s digital era, data is the new gold. Companies are constantly searching for ways to efficiently manage and analyze vast amounts of information to drive decision-making and innovation. However, with the growing volume and variety of data, traditional data processing methods often fall short. This is where Microsoft Fabric, Apache Spark and Delta Lake come into play. These powerful…

[seasons-of-death]

brother's best friend

pairing: rafe cameron x reader

genre: smutsmutsmut, minors DNI!!!

synopsis: your brother's best friend has never been too interested in you, but when he sees you after you spent the summer away, he sees you in a new light.

word count: 2.6k

a/n: i've been weirdly into blonde men lately. i might be mentally ill idk. anyway, this is my first time publishing smut so if this sucks i give everyone permission to throw tomatoes at me. and yes i finished writing this at 4am.

✩₊˚.⋆☾⋆⁺₊✧ ✩₊˚.⋆☾⋆⁺₊✧✩₊˚.⋆☾⋆⁺₊✧ ✩₊˚.⋆☾⋆⁺₊✧✩₊˚.⋆☾⋆⁺₊✧ ✩

You had known Rafe Cameron for as long as you could remember, and even some of your earliest memories featured him - you simply couldn't remember a time when you didn't know him.

Or, a time when you weren't crushing on him like crazy.

Sometimes, when you were unable to sleep, rolling around in your bed late at night, you couldn't help but cringe at the memories of being a little girl in pigtails and trying to get him to play kissing tag with you, or always bothering him and your brother when he was over, sticking to him like a burdock, or a barnacle. The memories always made you scream into your pillow.

He had always just seen you as his best friend's annoying little sister, some little girl who'd always stuck her nose into things that were none of her business, even though you were only a few years younger than they were. And even as you both got older, things stayed the same. You were nothing but his best friend's little sister.

Until one summer.

It was August, only one week until summer vacation would be over. You'd spent all of your summer at your grandparents' lakehouse five hours away from the rest of your family. And during that summer, a lot changed about you. You got hot.

Or, at least that was the only thing Rafe could think about when he saw you leaning against your kitchen counter, lazily scrolling on your phone while a small, heart-shaped lollipop was between your lips. You were wearing a flimsy black top and frayed denim shorts, and he could see a bit of the tan lines from your bikini from the thin straps of the top.

He had come by to meet up with your brother, but you had simply shrugged and said that he was out, and you didn't know when he'd be back, but that Rafe was welcome to wait for him. And that's how he ended up in your kitchen, unable to keep his eyes off of you, while you simply ignored him. It was unlike any time else; you'd usually be chatting his ear off about something, always wanting his attention. And he did find it adorable sometimes, but he had never really found you that enticing, until now, when you were almost acting like he wasn't even there, standing there, wearing barely anything.

You let out a sigh, rubbing your shoulder absentmindedly, causing your top to cling to your body even more, and his eyes widened when he realized that you weren't wearing a bra. But then, he realized how creepy it must be for him to stare at you, so he cleared his throat, trying his best to look away, while there was an obvious flush on his face.

"So, uh, how was summer?" He asked, trying to come up with something to talk about, and it seemed to work, as you put your phone away and shrugged.

"Pretty uneventful. I pretty much just did what I do here." You said, pulling the lollipop away from your lips with a pop, and he couldn't help but think about how your pretty, plump lips would look wrapped around his co- "How about yours?"

"Yeah, same here..." He said with a hoarse voice, painfully aware of the semi in his cargo shorts.

"Aw, come on." You said, walking over to the dining table he was sitting at, leaning to place your arms on it, basically bending over, allowing him a generous view into your cleavage as you placed the lollipop back in your mouth. "There has to have been something interesting. There's always something here."

"Nope." He muttered, almost unable to tear his eyes away from your cleavage, your nipples hard against the fabric of your flimsy top as you looked at him with raised brows, the semi in his shorts having turned into a proper tent. "Just the same old Outer Banks."

"Lame." You let out a dramatic sigh, pulling the lollipop away from your lips, the lollipop giving them a slight red tint. As you bit down on your lip, the only thing on Rafe's mind was how much he desperately wanted them against his lips.

"Can I ask you something?" He said suddenly, his eyes narrowing as he inspected you.

"Shoot."

"Are you trying to get me to fuck you?"

To say that his sudden and blunt question caught you off guard would be an understatement, your eyes widening and almost causing you to choke on your own spit as you looked at him.

"Cause if that's what you want I can just bend you over the counter right now."

He could see that some of your bravado had crumbled away, a flush that had nothing to do with the temperature creeping onto your cheeks as you cleared your throat and tried to straighten your back, acting nonchalant, but the slight tremor in your voice, as you spoke, was telling him everything he wanted to know. "Oh, yeah?"

He stood up with a grin, and he could see your eyes immediately shoot to the obvious hardness in his shorts, your breath hitching slightly before your eyes flicked back up to his, his hands creeping onto your hips, a part of his calloused hands meeting the slip of bare skin between your top and your shorts.

"You have no idea how much I wanna do that. Ever since I saw you in that top, I've just been wanting to take it off," Rafe slipped one of the spaghetti straps off your shoulders, "and get my hands on those pretty tits."

His hand brushed against the fabric covering your nipple, causing you to shiver and let out a small gasp as you leaned into his touch, clearly wanting more. He leaned closer to your ear, whispering in a husky tone.

"So, how is it? You want it?"

The words caused a wave of heat and desire to shoot to your core, as you nodded slowly.

"Say it. Say it, baby."

The commanding tone in his voice almost caused you to moan, as you looked at him in the eye, speaking with a shaky, trembling voice. "Yeah..."

With that, he had lifted you into the air, his strong hands around your thighs as he held you up, the veins in his arms pronounced as he carried you toward your bedroom.

The moment your back hit the bed, it was like something had taken over him. His body was immediately pressed against yours, his lips attached to yours as if by magnetic force, rough, sloppy kisses that neither of you could get enough of, his tongue slipping into your mouth as he kneaded your breast through the flimsy top.

You pulled at the hem of his shirt as he kissed you, and he pulled away slightly with a satisfied grin on his face as he pulled his shirt over his head, discarding it to the floor, your eyes immediately shooting to his abs.

"What? You like what you see?" He said with a cocky, shit-eating grin that might as well have been tattooed onto his face, and you ran your hands over his muscled, causing him to tense up as he let out a small groan.

His body was back on yours, as Rafe started pressing kisses down your neck, the little bites he'd occasionally sprinkle on your soft skin causing you to let out a small hiss until he ran his tongue over them as if soothing you. His hands were fumbling with the button and the zipper of your denim shorts while his lips were sucking marks into the skin of your neck, until he detached himself from you again, this time to pull your shorts off

He looked down at you, rubbing his chin slightly as he chuckled softly, looking down at you on your bed. Your black panties matched your top, and your lips were plumped even more by the kisses you two had shared, your hair messily thrown around.

"Fuck, you look gorgeous."

His hoarse words caused a flush to run through your body and you covered your face with your hands, before he leaned over you once again, pulling your hands away from your face, and gently pinned them to the mattress. "Don't you dare cover your face... I wanna see how pretty you look when I make you cum on my cock."

"Rafe..." You breathed out his name, making him grin as his hands released your wrists, and his hand slid under your top and up to your breast, kneading it roughly as you arched into his touch, your breathing now completely erratic.

He pulled your top over your head, his pretty lips immediately attaching themselves to your sensitive nipple, sucking it into his mouth in a way that caused you to let out lewd moans while his other hand kneaded your other breast, your hands now gripping your sheets tightly, trying to bite down on your lip.

You felt slightly relieved when his lips pulled away from your nipple, the stimulation driving you crazy with need and desire, only for him to attach his mouth to your other nipple, his hand now going to knead the breast that he just had in his mouth.

After a while, his lips started traveling lower, leaving little kisses and bites all over your abdomen, each of them feeling as if they were lighting up every single vein in your body. When his lips arrived at the waistband of your panties, he simply grinned up at you wolfishly, as he started pressing teasing kisses over your panties.

When he arrived at your clothed core, you let out a small whine, and he looked up at you, licking his lips. "Fuck, you're soaked... Ruined your pretty little panties, all because of me..." He said with a small groan.

"Rafe, please..."

"Please what, baby? Tell me what you want."

His commanding tone only added to your need to feel him in you, and if he was making you plead, then so be it. You weren't above begging for it, not when he had you like this.

"I want you... I need you, please..."

He let out a chuckle as he pulled away, going to unbutton his shorts, letting them pool at his feet before stepping out of them and throwing them away.

"Well, if you insist."

His fingers hooked on the waistband of your panties, throwing them to the floor and looking down at you filled with desire, the fabric of his boxers was starting to feel suffocating against his erection.

He took off his boxers, letting his dick free, and you look at him with slightly wide eyes. Based on his reputation, you would've guessed he was big, but not... big.

"What's wrong baby...?" He said, his body against yours once again, his cock so close to where you wanted, needed him the most. "Worried you won't be able to take me, huh?"

"Mmhm..." You hum with an uncertain nod, making him chuckle against your skin. "Don't laugh!" You say, feeling your face starting to warm up.

"It's okay, baby..." He brought his hand to your face, cupping your cheek, "I'll be gentle, just for you..."

His hand went to stroke the base of his cock, already leaking some precum as he looked down at your naked form, laying there all pretty and needy for him.

Rafe positioned himself at your entrance, looking up at you, pushing away some strands of hair that were messily strewn across your face. "You ready for me?" He asked, and as he rubbed his tip against your entrance, you couldn't help but let out a whimper that was just pure want. "Is that a yes?"

"Yeah... I'm ready..." You said softly, and you let out a high-pitched gasp when you felt him enter you slowly, feeling like he was filling you up even though all of him wasn't even in you yet.

"Fuck, you're tight..." He breathed out as he pushed more of himself into you, giving you time to get used to his size before he thrust all of him into you, causing you to let out a moan.

He started slowly moving inside of you, every bit of movement causing you to moan, arching into him, his name the only thing that managed to slip past your lips, your hands tightly clenching the sheets as you started to get used to the way he was stretching you out, your eyes pressed closed.

"You look so gorgeous like this, baby... God, I could watch your face forever..." He groaned, his hand traveling down to your aching cunt, his thumb starting to draw circles on your clit as he slightly picked up his pace, leaving you trembling underneath him with pleasure.

"Oh god, Rafe..." You moan under him, the way he was filling you causing your brain to start to short-circuit, his cock hitting that spot inside of you that made you feel so good, your legs wrapped around his torso, trying to pull him even closer to him, making him groan your name.

His ringed thumb was starting to pick up its pace on your clit, while he was thrusting himself into you harder and faster, making everything disappear from your mind, your eyes pressed closed. You could tell that you had lost all concept of volume control, but you didn't care; he was making you feel so good it was as if everything else in the world disappeared.

You felt the familiar feeling brewing up in your abdomen, and you clenched the sheets even harder, your moans turning breathier. "Fuck, Rafe, I'm so close..."

"Open your eyes for me, baby..." He said softly, "Want you to look at me while you cum on my cock like a good girl..."

I forced my eyes open, and as I looked at him on top of me, I couldn't help but let out a loud moan of his name, his thumb circling my clit, his cock hitting the right spot at the right pace.

"Come for me, baby... Let me see you come..."

The coil inside of your abdomen was building up, every vein in your body feeling like he had lit them on fire with his simple touch as you looked into his blue eyes as he thrust into you.

And then it just... snapped.

You felt yourself come undone, moaning his name as you climax, your cunt clenching around him so tightly it was making him groan as he tried to hold back his own release, determined to let you ride through your orgasm. You arched into him, tightening the hold your legs had around his waist.

But as you did so, it was the last straw for him. He felt himself spill into you with a groan while you were mid-orgasm, clenching around him as if trying to drain all of his cum out of him and into you, your moans mixing with his groans.

Heavy breaths filled the room as you both were getting down from your respective orgasms and when he pulled out of you and saw some of his cum leak out of you, he could swear he was starting to get hard again.

He collapsed onto the bed next to you, letting out a soft chuckle as he looked at you, both of you completely blissed out of your minds. He turned to his side, looking at you with a grin as he ran a hand over your bare chest.

"Has anyone told you how beautiful you look when you come?"

You could feel your cheeks warm up, causing you to chuckle as you turned to your side, hiding your head in his chest as he pulled you close to him, pressing a gentle kiss on the top of your head.

Suddenly, you could hear the front door open and close, and you looked up at Rafe with a small chuckle.

"I guess my brother's back."

"Aw, I was having much more fun waiting for him." He said with that familiar grin, pulling you into a soft kiss.

[wolfawaycamp]

Something with infected Kaitlyn maybe? <33 (best if she stays infected post-game and all counselors survive)

🐼 What if I told y'all this was based on a dream I had where this was more or less the intro to The Quarry 2? It's a sign, I tell ya!

Twelve-forty-two p.m. They were running late. Not good. Kaitlyn stared out at the water from the front steps of the lakehouse. They’d all agreed it was a worthwhile investment considering their…condition, but it was also quite isolated, which made for a long monthly road trip.

Sure, the sun wasn’t supposed to set for another four hours or so, but that didn’t stop Kaitlyn from running through every worst-case scenario in her head while she sat nervously awaiting the arrival of her fellow counselors.

Jacob strolled up and planted himself next to her. “Kait, I know that look. You’re getting antsy again.” She didn’t respond. “Hey, it’s probably just, I don’t know, typical New York traffic. People coming home for the holidays and all that.”

She looked over at her friend. “Yeah. Probably.” It could also be an accident, or maybe another attempted kidnapping, or god forbid one of the Hacketts found—

Thankfully, Kaitlyn didn’t need to finish that thought as she saw the familiar silhouette of Emma’s minivan pop up over the horizon.

“Party time!” Jacob grinned at Kaitlyn.

She rolled her eyes and strode toward the approaching vehicle. “You are probably the only person in the universe who gets consistently excited about exploding into a hairless mutt every month.”

“You say that like it’s a bad thing.”

She put one hand on her hip and glared at Jacob. “Uh, yeah. Because it’s fucking weird, dude.”

The van slowed to a stop a few feet away from the bickering duo, and it wasn’t long until seven familiar faces popped out, each carrying some sort of backpack or container in their arms.

“What took you so long?” Kaitlyn inquired, scanning the group. She knew her temper would be shorter than normal today, but she still felt she had the right to be a little upset.

While several of the counselors began transporting their luggage into the lakehouse, Abi rounded the van and plopped a large cardboard box down in front of Kaitlyn. “Hey, don’t be too mad at us. We brought some extras along. My idea.” She gestured toward the box.

Kaitlyn raised an eyebrow. “You went on a shopping spree?”

“Not exactly. I had these custom-made and today was the earliest we could pick them up. I’m really sorry it took so long.” Abi opened the box and revealed a brightly colored pile of woven fabric.

Kaitlyn grabbed the top item; it was dark green with a very loud yet charming pattern of fire-engine red bears prancing across it. She instantly recognized what these were supposed to be. “Ugly Christmas sweaters. Cute.”

“Aren’t they?” Emma hopped over. “That one’s Jacob’s. Mine’s the purple one with the stars on it, and yours—”

“Hey, hey, hey! Let’s save the gift-giving for when we’re all prepped for tonight,” Abi interrupted.

Ryan and Dylan had walked out of the house and approached the group, hands loosely linked together. Ryan spoke, looking slightly more on guard than normal, “She’s right. We’ve got an early moon tonight and I’m not sure I want to see what a ravenous Kaitlyn looks like.”

Now that he mentioned it, Kaitlyn’s stomach had been grumbling for the past few minutes. “Speaking of—” She spun around and entered the house, searching specifically for Jacob or Nick; they were tonight’s designated chefs. She found them unloading groceries in the kitchen. “How long’s that all gonna take to cook?”

Nick pressed a few buttons on the oven and turned to Kaitlyn. “It’s not too complicated; the sandwiches need to be assembled and then we’re just waiting on dessert. Hope you like sloppy joes and brownies!”

Kaitlyn tried not to get too excited thinking about it. “Sounds great! I’m gonna go over here now so you don’t have to see me drooling all over myself. Let me know when it’s done!” She wanted to do the rounds before getting too comfortable.

Making her way to the end of the hallway, Kaitlyn pulled a set of keys out of her pocket. She stood in front of the door at the end of the hall for a moment; this was going to be their home for tonight, and things needed to be double- and triple-checked before she and her fellow lycanthropes settled down.

“Everything good?” Dylan’s voice called out from behind her. She would have been annoyed if it was anyone else, but he somehow managed to stay in her good graces during full moons. They’d been in sync with each other, more or less, since that night at Hackett’s Quarry.

Kaitlyn nodded, unlocking the basement door. “Yep. Only need to do a quick basement check and we should be gucci.”

“But are you ready?” he asked.

She met his gaze; he looked anxious, rightfully so. They were about to jam a bunch of bloodthirsty animals into close quarters. Not exactly the holiday vacation they’d pictured. “As ready as I can be. Are you coming with, or…?” She nodded toward the staircase leading into darkness. He shrugged and wordlessly followed her downward.

After they’d confirmed that every inch of their enclosure was working as intended, the two joined the group for dinner, which was followed by a lazy hour of catching up and gossip.

Laura’s watch alarm went off. Four o’clock on the dot. Kaitlyn sat up straight, tensing up as if she was being sentenced for a crime.

“Alright. Time’s up, guys. Let’s get going,” Laura said calmly.

The infected individuals one-by-one filed into the underground cages. Once they were all locked in, they collectively relaxed into their quarters.

“Damn. We never got around to giving out the sweaters,” Emma lamented from the spot next to Kaitlyn.

Kaitlyn gave what was probably an unconvincing smile in response. “We’ll have plenty of time. After.”

Emma grinned back with a similar look of unease, but her words were sincere. “Deal. After.”

Kaitlyn supposed there were worse ways to spend her holiday vacation.

[elejah-wonderland]

elejah_au

*

_time travel fanfic_au

_another random part.

*

warning: smutty, 18+

*

@njeancastro316

*

New Orleans, 2035

A few months after Elena returned from 1988

Elena walked into her bedroom. It was one of those long days. All she wanted was a bubble bath. She took her phone out of the pocket and read Bonnie's message. 'We're going to New Orleans for the New Year's Eve. See you in a couple of days.xo'

Elena inhaled sharply. She didn't feel like celebrating anything. She wanted to get into a time machine and get back to Elijah.

Walking to the chest if drawers, she picked out a long shirt. And there, next to it was Elijah's shirt she took with her. One memento.

His scent, the very essence of him was woven into the fabric. She held the shirt closed to her chest. She missed him so much. She needed his touch. His lips on hers. His body next to hers.

Flashback

New York, 1988

"You said last night that you wished to get away for a few days. Have a different birthday. So, I took upon me to whisk you away to Louisianna." Elijah said.

"What? You're not serious?" Elena smiled.

"I'm very serious. We're flying out in an hour."

In Hammond, LA

Stepping out of the car, Elena's eyes glittered at Elijah seeing the place he had booked for their romantic getaway.

"I hope you are not disappointed?" Elijah said.

"Absolutely not. This is perfect. Reminds me of my family's lakehouse." Elena said, giving the Original a warm loving smile.

"Well, I'm very glad." Elijah turned to the valet, who met them, taking a suitcase out of the back of the Porsche. "Shall we?"

Elena nodded, curling up a smile.

Taking her hand in his they walked in the place to check-in.

Not long after, both were ready and met in a gazebo where a candelit light supper was served.

"OMG!" Elena exclaimed softly. "You pulled out - all the stops."

"It's a little something" the Original pulled the Champagne cork and poured the bubbly nectar into the flutes.

"This is - crazy romantic - thank you," Elena took the flute and clinked it with his, "this is really amazing."

"I do not wish to be soppy - but you've been the sunshine I've longed for a very long time."

Elena's eyes teared up. Her heart was beating like a drum. She gulped. A sudden shiver ran through.

"Are you all right?" the Original crinkled his eyebrows, stepping closer to Elena.

"Yes - it's just - all this - just got to me. It's stupid. I don't know why I'm so emotional"

And before she could turn away, he wrapped her gently in his arms, placing a loving kiss on her lips. And she melted into him.

The music started and she found herself swaying slowly, nestling her head on his shoulder, feeling his hands gently settling down her lower back. The soft music, his closeness, the warmth that radiated from his lips that now pressed on her cheek as she moved to face him, all was perfect. Her mellow eyes looked at his lovingly. She leaned forward, pressing a little kiss near his ear. A gentle movement of her warm breath in his ear moved everything inside of him. Without any words, he took hold of her hand and they left the dinner area, through the back porch, onto the garden. A few hundred yards away, they walked in the cottage.

Letting go off his hand, she now turned to him.

He cupped her face in both of her hands and kissed her lips.

Sliding underneath his suit jacket, sliding it off of his shoulders, tossing it lightly on the neighbouring armchair.

She didn't want to crease the expensive Armani, knowing all too well how much his suits cost, and how much he cared about them.

Elijah started unbuttoning his shirt now, slipping it out of his trousers, as he watched her unzip her dress, sliding it down her, her eyes gleaming at him. His probe her, wetting his lips, swallowing hard, lost in her beauty. Just one look at her and everything in him shook and stirred.

He complimented on her beauty as he walked over to her, locking her in his arms. Elena smiled knowing all too well how she affected him.

"You are not bad yourself" she murmured, gliding her hands up his hard muscles, beaming at him with her eyes sheeted with desire. Their lips met again, his softly tugging hers. His tongue darted in her mouth, entwining with hers, letting out a muffled groan as she pressed her body against his.

"You drive me crazy" he gasped.

"I've only just begun" Elena slipped and as found themselves close to the bed, she now pushed him on it. He freed himself of the shirt and she climbed on him, lowering her lips onto his, kissing him teasingly slow, as he mashed his hands into her long hair. Moving her lips to his jaw, she kissed the sweet dimple on the tip of his chin, sliding slowly down his neck.

She felt his breath stop, as she trailed small butterfly kisses down his chest and abs, stopping just below his belly button, looking up at him, meeting his dark eyes fully lost in the fire she had set alight.

"Don't stop" he breathed hoarsely.

"Don't plan to" Elena muttered. She now pulled down his pants along with his boxers, exposing his hardness. Her hands slipped around him, adoring him with her touch. Lowering her lips now on him, his heart went wild.

"Damn" he grunted, exhaling deeply as she took him in her mouth. His blood roared through his veins like wildfire, burning and stinging. It felt like she was devouring him whole. She moaned softly, and he clenched his eyes as delicious jolts of pleasure shot up his spine. Wet, sucking sounds intermingled with his grunts of pure pleasure. He was not going to take long and the next moment he shattered into million pieces, coming hard.

[writingonleaves]

meet our oc - amelie fishel

reckless driving au masterlist

**spoiler free!!**

The basics!

Amelie Iris Fishel was born on June 11, 2002 in Detroit, Michigan

Her mother, Elise is of French descent and her father, Thomas is a quarter Filipino on his mother’s side. 

Amelie studied at the University of Michigan from 2020-2024 on a full scholarship, graduating with a double degree in communications and design. 

She worked with the Michigan Athletic Department as a photographer, photographing practically every single sport at the college. She was assigned to photograph the men’s hockey team a good amount, thus becoming familiar with the players.

In her last two years, she was the TA in classes that Adam Fantilli, Rutger McGroarty, Gavin Brindley, Luca Fantilli and Nick Moldenhauer took. 

With her time photographing the hockey team, she became the closest (relatively to the others) to Ethan Edwards

Dated twice in college

First time was more casual with a girl named Sara that she met in one of her classes freshmen year. Ended up just fizzling out. They’re still friendly

Second time was more serious with Cooper Volt, a guy on the baseball team

Dated for a little over a year; broke up January of her junior year

Hoping to photograph sports at the professional level

She has two older sisters and is close with both of them.

Colette Susanna is six years older than Amelie. She works for Kate Spade in New York City in fashion merchandising. 

Charlotte Marie is four years older than Amelie. She is studying at Stanford University for her PhD in Physics. 

Danced all throughout her childhood until she graduated high school. At her most intense, she was dancing close to 20 hours a week. She danced a bit in college, but not as intense. 

Nicknames include Ami aka ah-mee (by Ethan and her sisters), Mimi (by Adam)

Key character traits: stubborn, ambitious, rational, blunt, loyal

Clothing style: headbands, bows, hair scarves, etc etc. Amelie loves having some sort of fabric in her hair. 

Bisexual

Meets Jack Hughes during the summer of 2024, when she’s staying at Stanley and Ruth’s — her grandparents — new lakehouse that’s located on the same street as Quinn and Jack’s lakehouse in Bloomington, Michigan. 

She had already known Luke from when they overlapped in college.

Random fun tidbits!

The kind of person who has very few close friends than a bunch of friends (quality over quantity vibes)

Attaches memories to place a lot, to the point where it’s sometimes detrimental

Textbook introvert

Observes and adapts very seamlessly to her surroundings, which helps her photography career

Beer hater

Very good pool player

Sweet tooth - always has some sort of chocolate with her at all times

Favorite musical artists: 5 Seconds of Summer, Chelsea Cutler, Lizzy McAlpine, Miley Cyrus, Maggie Rogers, Noah Kahan 

Big musical theater fan — some of her favorite musicals are The Last Five Years, Dogfight, Waitress and In The Heights

Out of the three Fishel sisters, Amelie is often seen as the most emotional yet hardest to crack.

Will always sing in the car

Loves La La Land

[bomberqueen17]

warmth & fashion

so here’s the problem, we’re coming down to the wire on this vacation we’re going on-- we’re leaving for Cartagena, Colombia early next week-- and I’m trying to mentally pack my suitcase, and-- I mean I’ve had some things set aside for over a month now, i’ve been preparing for a while-- but my real problem is that

this is sort of hilarious and embarrassing

i cannot remember for the life of me what it is like to be somewhere that the outdoors is warmer than room temperature. like i keep planning out outfits and i’m like “camisole and leggings for warmth, then-- wait” “I know I’ll need to dress warmer for travel than the destination but if I wear my leather jacket then I’ll have it for the evenings-- wait” and I know, intellectually I know, I live in a place where for part of the year, it is warmer than the ideal room temperature outdoors. I know this! I can leave my house in July and not bring a coat for later! i can wear a dress without an undershirt and leggings! these are things I do!

but I can’t remember how, and it’s really hilarious to me that my memory is so shit I can’t even remember what I wear when it’s July here.

I know enough that I made a bunch of linen and cotton dresses to bring, but I keep mentally accessorizing them with scarves and legwarmers and layered shirts and shit. *NO*.

Anyway, it’s kind of a hilarious problem to have but it is also a problem, I genuinely do not know what clothing I’m going to bring. i’m going to wind up filling my suitcase with leggings and socks I won’t want to wear once I’m there. Like, genuinely, I cannot conceptualize of a place where it is 85F.

Meanwhile, I also dug out my giant sun hat-- I have to figure out a way to bring it, it’s too great not to have-- and it’s sadly undecorated and I have become quietly obsessed with the notion of making fabric flowers to decorate it, in the like, thirty seconds I have left during which I need to be finishing the linen Rockwell dress. Last night I did manage to finish weaving the second waistband for it (I mentioned that i was inkle looming that, right? and that to accommodate my majestic girth I was going to have to make two waistbands and join them in the center front? anyway i finished the second one last night), and I also managed to finish hemming the maroon linen Honeybourne dress so I’m wearing that today and realizing that my hack of adding width to the bodice to avoid a zipper accidentally added width/depth to the neckline so it is wider and lower cut than I like, oh well that’s fine for summer right??? i don’t know!! because i don’t remember summer!! but anyway. i have it done.

The Rockwell, I put in the bust gathers, so now I just have to sew those down to a length of twill tape on the inside, and then I’m figuring out how to attach the belt on the outside so it’s removable for washing-- I might put a buttonhole where I join the two sides of the waistband, and then attach a button to the dress?? Enticing concept. I could then switch out waistbands for a whole different look to the dress!

The other thing that’s been exciting is like, for once in my life accessorizing-- that black and white slip dress matches a pair of great earrings I own, and the rainbow waistband for the Rockwell matches a pair of rainbow tassel earrings I own, and I just like, sometimes get excited about the concept of fashion, we’ll see how I do with this.

One time I camped with a girl who did Lolita fashion cons, and we weren’t doing that but she had all these beautifully-accessorized outfits and I was like “how??” and she was like “gallon ziploc full of accessories, packed separately with each outfit, never fail” and i have never achieved that but i’m gonna try. For the lakehouse weekend this winter I did pack each outfit rolled around its layers/accessories (including the compatible bra with each neckline) and that worked a treat, so. Might try it for this.

[msmargaretmurry]

eldest daughter quinn hughes!

katie you are so aware of what the eldest daughter quinn hughes gdoc is, so i can only assume you're angling for another snippet, which i will happily give you because we are breakfast bread pals ���� please enjoy another excerpt of sexy bad decisions at the lakehouse:

Brady pulls the bedroom door shut behind them, and Quinn has just enough time to become aware of her heart pounding in her ears like a subwoofer before his mouth is on hers again. He tilts her face up with both hands as they both stumble a little, more intent on the kissing than on staying upright, and she is suddenly more aware than she’s ever been of their six-inch height difference. She pushes up on her toes, into the kiss, hungry for it. They bump into the dresser, the corner jabbing her in the kidney. It’ll bruise. She doesn’t care.

It’s only a half-dozen steps to the bed. Brady scoops her up and climbs onto it without breaking stride, depositing her in the middle of the queen-sized mattress. Quinn has to muffle a surprised laugh at the manhandling, which makes Brady laugh, too, the sound bubbling like champagne in her ears. Quinn thumps him on the shoulder.

“Be quiet,” she hisses.

“You started it,” he retorts in a whisper. He’s grinning, cheeks flushed, eyes bright.

“Shut up,” Quinn says, and pulls him down, fitting their mouths together. She lets her legs fall open, lets him settle between them, welcomes the weight of him as the kiss turns long and slow and deep. There’s still too much fabric between them, but the friction is better like this. The bulge of his dick slides between her thighs, a delicious preview of what she really wants. He’s going to feel so good inside her. She’s so wet already; he’s going to slide right in, fill her up, send her tumbling over the edge. 

“Hey,” Brady says, somehow finding space for the word in the insistent press of their mouths. Quinn hums a response, but he shifts to kiss the corner of her lips instead, then her cheek. “No, hey, can I take your shirt off?”

“What, no ‘please’?” Quinn asks, sitting up enough that he can skim his hands up her sides, taking the tank top with them. She lifts her arms for him to pull it over her head, then reaches for his t-shirt. “Where’s your manners, Tkachuk?”

“What are you gonna do, tell my mom?” He shrugs out of his shirt with some help from Quinn that hinders more than helps, but they get there, and he tosses both garments into the darkness of the room. 

“I can’t believe I have to say this,” Quinn starts, then squeaks as he pins her back down, ducking his head to nuzzle her throat. He hasn’t shaved since that morning, and even though his facial hair is embarrassing at best even when he’s trying, the prickle of it is still surprising. She hits him in the shoulder again, less hard than she’d like to due to the distraction. “Don’t mention your mom in bed.”

[tippysattic]

Check out this listing I just added to my Poshmark closet: Simple Day at the Lake Quilt Sewing Pattern.

[rajaniesh]

Unlock Data Governance: Revolutionary Table-Level Access in Modern Platforms

Dive into our latest blog on mastering data governance with Microsoft Fabric & Databricks. Discover key strategies for robust table-level access control and secure your enterprise's data. A must-read for IT pros! #DataGovernance #Security

[technical-shorts-datatools]

Microsoft Fabric - Introduction of Lakehouse and It's Limitations

[sql-datatools]

Microsoft Fabric - Introduction of Lakehouse and It's Limitations

[fazizov]

How to build Real-Time Analytics on Microsoft Fabric Lakehouse tables

Are you curious about how to build #RealTime Analytics on top of ever-changing Lakehouse tables? How to build a smart alerting and monitoring system instantly reacting to the changes in your data? In this video, I explain how to use Delta Lake Change Data Feed, #Spark Structured Streaming, Event Streams and Data Activator in #MicrosoftFabric to build an end-to-end #RealTime Analytics System. Check out here: https://youtu.be/RIpXnmQm8XA

[satyakideworld]

Demystifying Modern Data Technologies: Insights from the Global PowerBI Summit

At the Global PowerBI Summit, we explored Lakehouse, Fabric Pipeline, and Notebooks versus Databricks, revealing advantages in data governance, usability, and performance. Fabric's efficiency in model execution and data loading. #fabric #summit #cloud #ms

In an engaging session at the Global PowerBI Summit, we and our co-host delved into the evolving landscape of data technologies. Our discussion aimed to illuminate the distinctions and applications of several pivotal technologies in the data sphere, ranging from Lakehouse vs. Storage Account to the nuanced differences between Fabric Pipeline and Data Pipeline and the critical comparisons of…

[microsoftfabrictraining]

Introduction to Microsoft Fabric Lakehouse

Microsoft Fabric was not specifically associated with lake houses. However, it's possible that there have been developments or new features introduced since then. Please note that the information provided here might not be the latest, so it's a good idea to check the official Microsoft documentation or other reliable sources for the most up-to-date information.

If you want to explore Lake House architecture in a Microsoft ecosystem, you might consider using Azure services. Here are some general steps to get started:

1. Azure Data Lake Storage (ADLS): Start by creating an Azure Data Lake Storage account. ADLS is a scalable and secure data lake solution that integrates well with other Azure services. Microsoft Fabric Training    

2. Data Ingestion: Ingest your data into ADLS. This can include both raw and processed data. Azure provides various tools for data ingestion, such as Azure Data Factory for ETL processes or Azure Storage Explorer for manual uploads.

3. Data Processing:  Utilize Azure services like Azure Data bricks, Azure Synapse Analytics, or Azure HDInsight for processing and transforming your data. These services support big data and analytics workloads. Microsoft Fabric Online Training Course

4. Metadata Management:  To manage metadata and facilitate data discovery, consider using Azure Purview. Azure Purview helps you discover and understand your data assets across your organization. Microsoft Fabric Online Training    

5.  Query and Analytics:  Leverage tools like Azure Synapse Analytics (formerly SQL Data Warehouse), Azure Data bricks, or Azure Synapse Studio to query and analyze your data.

6. Delta Lake or Delta Tables: if you are working with Azure Data bricks, you might consider using Delta Lake or Delta Tables for managing your data lakes. Delta Lake provides ACID transactions and versioning to your data lake. Microsoft Fabric Training In Hyderabad   

7. Power BI Integration: Use Microsoft Power BI for creating visualizations and business intelligence reports based on your processed data. Microsoft Fabric Training in Ameerpet

8. Security and Access Control:  Implement proper security measures and access controls using Azure Active Directory to manage permissions and ensure data security.

Always check the official Microsoft Azure documentation for the latest features and best practices related to Lake House architecture on the Azure platform. Additionally, you may want to explore any specific updates or new services introduced after my last update in January 2022.

Visualpath is the Leading and Best Institute for learning MICROSOFT FABRIC Online Training in Ameer pet, Hyderabad. We provide Microsoft Fabric Online Training and you will get the best course at an affordable cost.

Attend a Free Demo Call at - +91-9989971070.

Visit Our Blog: https://microsoftfabric.blogspot.com/

Visit: https://www.visualpath.in/microsoft-fabric-online-training-hyderabad.html

[microsoft-fabric]

Microsoft Fabric – Meet the powerful, cutting-edge data analytics platform

What is Microsoft Fabric?

Microsoft Fabric is an all-in-one analytics solution for enterprises that covers everything from data movement to data science, Real-Time Analytics, and business intelligence. It offers a comprehensive suite of services, including data lake, data engineering, and data integration, all in one place.

With Fabric, you don’t need to piece together different services from multiple vendors. Instead, you can enjoy a highly integrated, end-to-end, and easy-to-use product that is designed to simplify your analytics needs.

The platform is built on a foundation of Software as a Service (SaaS), which takes simplicity and integration to a whole new level.

SaaS foundation

Microsoft Fabric brings together new and existing components from Power BI, Azure Synapse, and Azure Data Factory into a single integrated environment. These components  are then presented in various customized user experiences.

Fabric brings together experiences such as Data Engineering, Data Factory, Data Science, Data Warehouse, Real-Time Analytics, and Power BI onto a shared SaaS foundation.

This integration provides the following advantages:

With the Microsoft Fabric SaaS experience, all the data and the services are seamlessly integrated. IT teams can centrally configure core enterprise capabilities and permissions are automatically applied across all the underlying services. Additionally, data sensitivity labels are inherited automatically across the items in the suite.

Fabric allows creators to concentrate on producing their best work, freeing them from the need to integrate, manage, or understand the underlying infrastructure that supports the experience.

Components of Microsoft Fabric

Microsoft Fabric offers the comprehensive set of analytics experiences designed to work together seamlessly. Each experience is tailored to a specific persona and a specific task. Fabric includes industry-leading experiences in the following categories for an end-to-end analytical need.

Fabric brings together all these experiences into a unified platform to offer the most comprehensive big data analytics platform in the industry.

Microsoft Fabric enables organizations, and individuals, to turn large and complex data repositories into actionable workloads and analytics, and is an implementation of data mesh architecture. To learn more about data mesh, visit the article that explains data mesh architecture.

OneLake and lakehouse – the unification of lakehouses

The Microsoft Fabric platform unifies the OneLake and lakehouse architecture across the enterprises.

OneLake

The data lake is the foundation on which all the Fabric services are built. Microsoft Fabric Lake is also known as OneLake. It’s built into the Fabric service and provides a unified location to store all organizational data where the experiences operate.

OneLake is built on top of ADLS (Azure Data Lake Storage) Gen2. It provides a single SaaS experience and a tenant-wide store for data that serves both professional and citizen developers. The OneLake SaaS experience simplifies the experiences, eliminating the need for users to understand any infrastructure concepts such as resource groups, RBAC (Role-Based Access Control), Azure Resource Manager, redundancy, or regions. Additionally, it doesn’t  require the user to even have an Azure account.

OneLake eliminates today’s pervasive and chaotic data silos, which individual developers create when they provision and configure their own isolated storage accounts. Instead, OneLake provides a single, unified storage system for all developers, where discovery and data sharing is trivial and compliance with policy and security settings are enforced centrally and uniformly. For more information, see What is OneLake?

Organizational structure of OneLake and lakehouse

OneLake is hierarchical in nature to simplify management across your organization. It’s built into Microsoft Fabric and there’s no requirement for any up-front provisioning. There’s only one OneLake per tenant and it provides a single-pane-of-glass file-system namespace that spans across users, regions and even clouds. The data in OneLake is divided into manageable containers for easy handling. The tenant maps to the root of OneLake and is at the top level of the hierarchy. You can create any number of workspaces within a tenant, which can be thought of as folders.

The following image shows the various Fabric items where data is stored. It’s an example of  how various items within Fabric would store data inside OneLake. As displayed, you can create multiple workspaces within a tenant, create multiple lakehouses within each workspace. A lakehouse is a collection of files, folders, and tables that represents a database over a data lake. To learn more, see What is a lakehouse?.

Every developer and business unit in the tenant can instantly create their own workspaces in OneLake. They can ingest data into their own lakehouses, start processing, analyzing, and collaborating on the data, just like OneDrive in Office.

All the Microsoft Fabric compute experiences are prewired to OneLake, just like the Office applications are prewired to use the organizational OneDrive. The experiences such as Data Engineering, Data Warehouse, Data Factory, Power BI, and Real-Time Analytics use Onelake as their native store. They don’t need any extra configuration.

OneLake is designed to allow instant mounting of existing PaaS storage accounts into OneLake with the Shortcut feature. There’s no need to migrate or move any of the existing data. Using shortcuts, you can access the data stored in Azure Data Lake Storage.

Additionally, shortcuts allow you to easily share data between users and applications without moving or duplicating information. The shortcut capability extends to other storage systems, allowing you to compose and analyze data across clouds with transparent, intelligent caching that reduces egress costs and brings data closer to compute.

Note: PreludeSys is a Microsoft Gold partner.

The original source of the content is learn.microsoft.com/en-us/fabric/.