# 11. Build a rekey table

![](/files/-MDZcWz48ABVyx3VZwqR)

1\) As we can we have WEATHER Stream which is of JSON type & we change the Serialization to AVRO shown below while creating another stream from it named as WEATHERRAW.

![](/files/-MDZdLd78KNkqDyylxpt)

2\) Now decscribe the new created WEATHERRAW stream .

DESCRIBE EXTENDED WEATHERRAW

![](/files/-MDZddH-ge5Q7cpXXgJV)

3\) If we do a select we can see that rowkey is null.

![](/files/-MDZdw37Ae7J-mygNueQ)

4\) Now build a rekey here :

![](/files/-MDZe7pFvGcpVvLBYu34)

![](/files/-MDZeDhb_gnouzreDg69)

\>> Now we can see we have a rowkey based on the partition applied.

![](/files/-MDZeNA8pgMHjUMiXyoH)

![](/files/-MDZeXNeDSvhuK-pmQAl)

\>>Now create a table in KSQL :  (TABLE is used for current :::::: whats the current weather now thats why we have created a table on top of the stream.

![](/files/-MDZemzmLYZSeLCuaI2S)

![](/files/-MDZf64aWwuwUHd57ilL)

![](/files/-MDZfJapGMxBi4e5IGQe)

\>>>>Now use the updated JSON :

![](/files/-MDZfSk5Cnfhtlk6h7Aq)

![](/files/-MDZfWnfETbmSdKvi4Vb)

\>>>Now update the same topic :

![](/files/-MDZfhtty86X1qi7ftxF)

![](/files/-MDZfowwlbkG2aB2xtyj)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://architectures.gitbook.io/project/apahce-kafka/ksql-on-ksqldb-for-stream-processing/ksql-intermediate/11.-build-a-rekey-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.