# sql cell does not work with data source

**URL:** <https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711>\
**Category:** Help\
**Created:** [March 9, 2023, 8:40am UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711 "2023-03-09T08:40:31Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![jchrist](https://avatars.discourse-cdn.com/v4/letter/j/858c86/32.png) [@jchrist](https://talk.observablehq.com/u/jchrist)\
**Post date:** [March 9, 2023, 8:40am UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/1 "2023-03-09T08:40:31Z")

</div>

Yesterday it worked fine, but today all sql cells in this notebook don´t work with the input table: [Stadtteile im Vergleich / RND | Observable](https://observablehq.com/@rnd/stadtteil-vergleich)

this is the code of the data source:

```auto
stadtteile_ranking_long = FileAttachment("stadtteile_long.csv").csv().then(
  function(data) {
    data.forEach(function(d) {
      d.Wert = +d.Wert;
    });
    return data;
  }
)

```

---

<div class="post-metadata">

**Author:** ![Fil](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.observablehq.com/fil/32/207_2.png) [@Fil](https://talk.observablehq.com/u/Fil)\
**Post date:** [March 9, 2023, 9:09am UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/2 "2023-03-09T09:09:12Z")

</div>

Thank you for the bug report. We are investigating and will report shortly.

---

<div class="post-metadata">

**Author:** ![jchrist](https://avatars.discourse-cdn.com/v4/letter/j/858c86/32.png) [@jchrist](https://talk.observablehq.com/u/jchrist)\
**Post date:** [March 9, 2023, 2:48pm UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/3 "2023-03-09T14:48:31Z")

</div>

is there a workaround for this problem?

---

<div class="post-metadata">

**Author:** ![mootari](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.observablehq.com/mootari/32/581_2.png) [@mootari](https://talk.observablehq.com/u/mootari)\
**Post date:** [March 9, 2023, 3:06pm UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/4 "2023-03-09T15:06:13Z")

</div>

Not an easy one, but we’re about to publish a fix. Thank you for your patience! 🙏

**Edit:** Fix published! 🎉

---

<div class="post-metadata">

**Author:** ![jchrist](https://avatars.discourse-cdn.com/v4/letter/j/858c86/32.png) [@jchrist](https://talk.observablehq.com/u/jchrist)\
**Post date:** [March 9, 2023, 3:29pm UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/5 "2023-03-09T15:29:16Z")

</div>

yeah! Thank you

---

<div class="post-metadata">

**Author:** ![jchrist](https://avatars.discourse-cdn.com/v4/letter/j/858c86/32.png) [@jchrist](https://talk.observablehq.com/u/jchrist)\
**Post date:** [March 9, 2023, 3:38pm UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/6 "2023-03-09T15:38:01Z")

</div>

![bug](https://canada1.discourse-cdn.com/flex030/uploads/observablehq/original/2X/3/3eda1cc001e9b965c4c72c21837e68948b807126.png)  
the embed still throws this error

---

<div class="post-metadata">

**Author:** ![mootari](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.observablehq.com/mootari/32/581_2.png) [@mootari](https://talk.observablehq.com/u/mootari)\
**Post date:** [March 9, 2023, 4:15pm UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/7 "2023-03-09T16:15:24Z")

</div>

@jchrist That might be your browser cache:

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/observablehq/original/2X/f/f2ca807ec88c090f741a01300a7c029c49f58c0a.jpeg)

Can you share the URL where you are embedding your notebook?

---

<div class="post-metadata">

**Author:** ![jchrist](https://avatars.discourse-cdn.com/v4/letter/j/858c86/32.png) [@jchrist](https://talk.observablehq.com/u/jchrist)\
**Post date:** [March 9, 2023, 8:23pm UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/8 "2023-03-09T20:23:26Z")

</div>

I cleared the cache, tried it in different browsers and with a forked version but still get this error. The website where it is embedded is not published yet.

 ![firefox](https://canada1.discourse-cdn.com/flex030/uploads/observablehq/original/2X/2/22bfbb8a29e0e9f30bc696d099a509e1a66a0413.png)

---

<div class="post-metadata">

**Author:** ![annie](https://yyz2.discourse-cdn.com/flex030/user_avatar/talk.observablehq.com/annie/32/3151_2.png) [@annie](https://talk.observablehq.com/u/annie)\
**Post date:** [March 9, 2023, 10:29pm UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/9 "2023-03-09T22:29:42Z")

</div>

sorry for the trouble, there was one last part of the fix that we missed! the embed should work now, although you may want to replace `runtime@5` in the generated code with `runtime@^5.5.1` to make sure that you’re getting the latest version. please let us know if you’re still seeing issues.

---

<div class="post-metadata">

**Author:** ![jchrist](https://avatars.discourse-cdn.com/v4/letter/j/858c86/32.png) [@jchrist](https://talk.observablehq.com/u/jchrist)\
**Post date:** [March 10, 2023, 9:46am UTC](https://talk.observablehq.com/t/sql-cell-does-not-work-with-data-source/7711/10 "2023-03-10T09:46:27Z")

</div>

thank you for fixing it so quickly!
